Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO OLE Bind
Message
From
01/06/2001 06:56:23
 
 
To
01/06/2001 06:39:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00513621
Message ID:
00513655
Views:
14
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.com
ICQ #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.
Previous
Reply
Map
View

Click here to load this message in the networking platform