Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
General field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00427023
Message ID:
00427116
Vues:
17
>>I need to pull photos from SQL Server 7 where they are stored in general fields, but VFP 6 or 7 doesn't seem to be able to do anything with them. Anyone know what's going on?
>
> Use OLE Bound Control tied to general field to show pictures.
> In addition, MS recommends also to use 'DoVerb' for general fields, but I know little about that and I never seed complete list of commands for different types of General field content.
> If you don't have much of photos on server (just started new project), I recommend you do not use general fields at all to store binary data. I tried the same to store different kinds of document files (pictures, DOC files, ZIP archives), but seems VFP have no function reverse to 'APPEND GENERAL' command, so I decided to use another approach. It is quite complex, but more reliable and allows to save any binary data of any size on SQL server. If you're interested, I may post this solution here.

Yes, I would be interested. I have no choice but to try to get the data out of SQL Server. I need to be able to at least pull the pictures up via modify general then copy the file to the clipboard. From there I should be able to do a strtofile(). If I can get to the data without the errormessages I'm currently getting, I'll be in good shape.

Post your code, I'll use what I can.

Thanks,
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform