FiveTech Support Forums

Hello All,

Im Using Ads 8.1 How can I save BLOB (image) via SQL script/command?

I tried:

AdsPrepareSQL()

AdsSetBinary()

AdsExecuteSQL()

But "Error: Unresolved external.." on ADSSETBINARY()

Any help?

Regards,
FAP

This is not direct answer to your question.
But i we want to store images in ADT table, we can easily store then and retrieve them in IMAGE type column. We can store and retrieve image data just like a memo field.

Please see \fwh\samples\xbradt.prg. The images stored can be browsed inline and also printed by report method of xbrowse

Here is a screen shot from xbradt.prg:


When it is so simple to handle images, why should be bothered to adopt more complex blob methods?

Dear RAO,

My simple method is this function to put image (blob) into the table (ADT/FoxPro)...



works all the time.

But I have this SQL string/command which I need to include the blob fields to insert the image.

btw,
the connection is via internet.


I wish to discuss the subject further.

My best regards,
FAP

The simplest thing I do ( ADT, ADS_CDX and DBFCDX ) is this:

ALIAS->FIELDNAME := MemoRead( <imagefile> )

Thanks RAO for the advise.

Regrads,
FAP