BLOB in SQL statement

[fraxzi]

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

[nageswaragunupudi]

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?

[fraxzi]

Dear RAO,

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

Code: Select all  Expand view

lSaved := BLOB->( AdsFile2Blob(cImgFile, 'PICTURE', ADS_IMAGE) )  
 

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

[nageswaragunupudi]

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

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

[fraxzi]

Thanks RAO for the advise.


Regrads,
FAP