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 ?
Any Idea is apreciated.
TIA
[ ],s
Peter