Since you are using SqlAnywhere, when updating your data, always use an embedded UPDATEBLOB statement. Don't even think of trying to update your blob field by doing an Update() on the datawindow which might contain the blob field.

See https://www.appeon.com/standardsupport/search/view?id=2204

regards.

varchar(32000) or whatever your max size would be.

then:

Defining edit styles - - Users Guide (appeon.com)

https://docs.appeon.com/pb2019/pbug/ch21s07.html#d0e40077

Hi Andrew;

• You would use a Blob column in SA - which is the Long Binary data type in SA
• Use the SelectBlob PB command to retrieve the Blob (RTF) data
• Load the RTF data into either a RT DWO or RTE Control
• Use the UpdateBlob command to insert / update the RTF based Blob data in SA.

HTH

Regards ... Chris

Chris

Thanks for that.

Question once i get the blob from the database, how do i assign it to the Rich Text Control ?

• Load the RTF data into either a RT DWO or RTE Control

how do i convert the blob to string ?

And then how do i put it back ? do i use the following code - converting the string to blob

string ls_notes

blob lblb_blob

ls_notes=ret_1.copyrtf()

lblb_blob=blob(ls_notes)

then use updateblob - sql command