>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.
OffThere is no place like [::1]