Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Images management
Message
De
09/01/2023 11:35:43
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
09/01/2023 11:03:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01685745
Message ID:
01685747
Vues:
40
>Hello all,
>
>For inventory management purposes I have to add images.
>
>I could add images two ways
>
>1. Only keep path and file in a character field
>2. Have the image in a field.
>
>The thing is that eventually I'll have to display product names and images in a grid. From that grid, the user will be able to select a product.
>
>If I put image in a field, what will be the type of that field?
>If I put image in a field, will the user be able to pick which image goes with which product and then save the information in the table.
>
>Thank you.

Do not store images in VFP tables, just use file information.
- Storing pictures results in large tables / memo files, with limited size
- general is crap, since it depends on the program storing the data available for showing the data

How you relate the picture to your product data - this is a complex design question. I can not tell you how many pictures per product, how many products per picture, how often you need to update the pictures etc.
I tend to create a folder next to the database and copy pictures there (while assigning to the table). Since the folder is located fix relative to the database, I just store a filename. In case I need to backup the database I just zip the database folder with the pictures, so all is contained and I can restore on every comp.
Not fool proof, but better then pictures scattered over HD / network / name it.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform