BLOB

[Gaurav kumar]

Hi reader,

Can you send me short code for storing and retrieving image from database table.

Thanks,
Gaurav

 

[Osborne]

Two examples here:

Progress KB - How to store binary files in a BLOB field

How to store binary files in a BLOB field

knowledgebase.progress.com

Progress KB - 4GL/ABL: Sample code using the IMPORT and EXPORT statements with BLOB fields.

4GL/ABL: Sample code using the IMPORT and EXPORT statements with BLOB fields.

knowledgebase.progress.com

Just substitute the TEMP-TABLES references for database references and the main parts being:

Storing:

COPY-LOB FROM FILE vFileName TO dbStorage.MyStoredBLOB.

Retrieving:

COPY-LOB FROM dbStorage.MyStoredBLOB TO vFileName.