BLOB

Gaurav kumar · Jun 2, 2019

Hi reader,

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

Thanks,
Gaurav

Osborne · Jun 3, 2019

Two examples here:

knowledgebase.progress.com

knowledgebase.progress.com

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

Storing:

Code:

COPY-LOB FROM FILE vFileName TO dbStorage.MyStoredBLOB.

Retrieving:

Code:

COPY-LOB FROM dbStorage.MyStoredBLOB TO vFileName.