Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to translate SQL Picture (binary array) to DBF Pictu
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00458797
Message ID:
00458854
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform