saving image (jpg, bmp) to MS SQL server - binary field

Hi

How do you save an image (ie jpg, bmp etc) to an MS SQL server - binary field using OLEDB in Windev12?

Thanks for your help.
JAROH

Jaroh,
for OLEDB you may use HOpenConnection() with hOledbSQLServer as the connectiontype-constant.
Then you can use HExtractMemo() and HLinkMemo() to save/read images.
Define your fields as "Sound,image,binary" with subtype "Image(binary memo)". Maybe other subtypes will work as well. This will lead to an "image" type field in MSSQL.

We use a MSSQL database this way, for scanning documents. It's holding nearly 800.000 images now and is about 180GB. Still growing..

Arie