Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to translate SQL Picture (binary array) to DBF Pictu
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00458797
Message ID:
00458854
Views:
18
>Assuming you're talking about image field at the SQL Server, query to image field in the SQL Server returns result with General field. However, it is quite hard to work with and maintain general fields in application. They're also quite slow and not portable, not reliable etc.

Vlad,
The image is from an ADO Records set. I'm trying to
SQL Pict -> ADO ADLONGVARBINARY - > to VFP (Cursor/DBF) General or Picture Field

With SQL;
for ex: SQLEXEC(handle,[SELECT * FROM CATEGORIES],[MyCusrsor])
The SQL Pict translates to a General FIeld in the VFP CUrsor

But in ADO it becomes a ADLONGVARBINARY type: The ADO image has an ALEN() (does that mean its an array?)
There a GetChunk method. But the Error (NOT CHATACTER DATA, or something similar error) occurs when APPEND GENEERAL is issued.

I will check the documents. Thanks
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform