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:
00427028
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.
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform