Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Images management
Message
From
09/01/2023 11:35:43
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
09/01/2023 11:03:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01685745
Message ID:
01685747
Views:
39
>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]
Previous
Reply
Map
View

Click here to load this message in the networking platform