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 ?
--sb--