Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Store Picture in General Field.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00428754
Message ID:
00428971
Vues:
21
>>Others may disagree but I generally keep the path to a picture in a character field and point the picture property to the path when needed. General fields are more trouble than they are worth IMO. HTH
>
>I'm fully agree with you, storing the pictures in the table is a pain. The table will grow and grow, and search times will be going down. I always store only the path.

Pablo, I disagree with you. I use 2 separate tables to store binary data. First table (documents) is main and used for search. Second table is binary data only related with documents table by ID. And space such data storing takes is not more than space that stored files takes on disk - no difference.

You may store binary data in VFP using memo fields. There are some tricks with binary data storing on SQL server using VFP. Search threads here for more information, this was already discussed during last 2 weeks.
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