Hi!
To read:
- Get the content of the image field in the ADO recordset into string using the ADO stream object
- store that stringthe into the memo field of some cursor or table.
- fix (hack) the field type manually to make it as general.
Than you can display that general field in the OLEBoundControl.
To save changes, do opposite:
- change the field type to memo
- get a string
- save it in the ADO recordset using field AppendChunk method
Read the FAQ#7995. As you see, it is not so easy to work with general fields in VFP. From FAQ article you can get a general idea. In your case the sequense of operations will be as described above. If you need more details on how to read and write image field data from/to ADO field, let e know, though I guess you already know this.
HTH.
>Thanks I got the grid all figured out...
>
>The problem is:
>I have either a varbinary or image type on SQL Server (don't really know which one is best?) and I want to bind it to an OLE Control in a VFP form.
>To display an embedded spread sheet or image.
>
>Also needs to work on reports if possible.
>
>(Like it would work with a General Field and append general in VFP)
>
>I tried setting the control source to
>orecordset.fields("olefield") but it didn't work.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.