Replacement for Updateblob

[DrBee]

I'm converting a PB6.5 application from Sybase System 11 to MSS 2000. I am having touble with the following embedded SQL statement:

blob lb_tot_document
UPDATEBLOB Fulfillment_Letter_Type
SET letter_text = :lb_tot_Document
WHERE letter_id = :ll_LetterId USING SQLCA ;

It does not update. I get sqlcode = 0, sqldbcode = 156 and sqlerrtext = Incorrect syntax near the keyword 'NULL'. I don't use the keyword 'NULL'.

Any ideas for an equivalent replacement.

 

[Guest_imported]

Maybe the value of lb_tot_document or ll_LetterId is null

 

[DrBee]

The UpdateBlob in this example was trying to place an initial value into letter_text which initially is null. Since the blob is not stored in the row with the remaining data it uses a pointer in the field letter_text that points to its location. This field will not have any pointers until it gets initialized. To make this happen I had to change the data base definition to default letter_text to a non-null value thus giving it a location and pointer.

This was not a problem in Sybase but it was in MSS 2000.