How to Convert SelectBlob and Updateblob to MS SQL Server 1

[DrBee]

I am converting an application from Sybase SQL Server to Microsoft SQL Server 2000 and I need to know how to convert the following two embedded SQL statements:

blob lblb_letter_text
selectblob custom_letter
into :lblb_letter_text
from Fulfillment_Letter
where fulfill_id = :ll_fulfill_id using sqlca;



BLOB lb_rte
UPDATEBLOB Service_Referral
SET profile_rte = :lb_rte
WHERE service_plan_id = :il_service_plan_id ;

 

[EdWall]

According to the PowerBuilder Documentation, this doesn't seem to need any conversion.

The only warning the documentation gives is to state that the AutoCommit property of the transaction object should be set to True for both the DBMSs that you mention.

Are you getting a compilation error?

Ed