Sergey, thanks for the help.

I'm playing with CA and SQL Server Image fields also in VFP 9.0
When I define the type in the CursorSchema to W (Blob) for the SQL Server's Image field in VFP 9.0 and try to Drag and Drop the field to the Form I can't get any type of Object to insert into the form.
Any Idea wich way to show a Blob field in a Form from a CA ? (Wich object to use)

PS: I changed the MapBinary property to .T. to get the Blob type in the Cursor.

TIA
[ ], s
Peter

>Hi Peter,
>
>For VFP9 see Re: Blobs and ODBC Message #925068. For VFP8 and earlier, How to work with Image field type on SQL Server (binary data)? FAQ #7995
>
>>It's my first try with SQL Server and image type for a possible new app.
>>I need to show pictures stored in a image column in SQL Server.
>>Before starting I was testing with the Pub_info table in the Pubs database..
>>

>>cStringConnect =("DRIVER={SQL Server};SERVER=BOSS700;UID=xyz;PWD=zyx;DATABASE=Pubs;Network=DBMSSOCN")
>>nHandle = SQLStringConnect(cStringConnect)
>>cSQL =  "SELECT * from Pub_info"
>>?SQLExec(nHandle , cSQL)>= 1
>>BROWSE
>>

>>
>>It returns a cursor called sqlresult as expected, but when I click twice in where's the logo image, I get this message...
>>

>>OLE object is invalid or corrupted.
>>

>>Any Idea why I get this error ?, or better, how can I show the image in VFP ?
>>
>>In VFP 8.0 and 9.0 its a GENERAL type field the cursor created where the image should be.
>>In VFP 9 exist a new datatype called Blob, so why if I get the image into a cursor it stores the data in a General data field and not in a Blob field, it makesmore sense if there is a Blob field to store images in those fields.
>>Is there a way to store a image form a SQL Server into a BLOB field in VFP ?
>>Any new parameter in a SELECT statement to return the image into a bLob field ?