for maximum flexibility you want to consider keeping filename and path in seperate fields. In large systems you'll sometime need to move whole sets of images. This is easy when all you need to do is change the path field.
completely agree with everyone who has tried to discourage you from using general fields - or even blobs - and storing the images themselves in the data.
>>Do you want to keep image in table field or as separate file?
>>
>
>I would prefer to keep them in separate files if possible.
>
>>>I am starting a new thread because I got the program working so that a form can add a BMP image to a general field and display it on the form and in a report and I think I know the questions to ask.
>>>
>>>I now want to enhance the program so that it can do the same with JPEG and TIFF images (which are smaller and which they user can get when he scans objects). If possible I want to either save the images in the table or to point to the image file. While the second option might use less space the first one might be easier to implement.
>>>
>>>I am willing to change the field where images are stored to another field type. The current form has buttons to move the pointer in the table top, next, prev, and bot. It also has buttons to add new data and edit existing data. In both cases it has a tab to add or change an image. Clicking on the Add/Change Image displays a GETPICT dialog. There is also a Remove Image Button on the Picture tab. The Picture tab also has a place to display the picture.
>>>
>>>My questions are:
>>>
>>>1. What should I change the table field to?
>>>2. What properties should the buttons move the pointer?
>>>3. What should the click methods of the buttons that move the pointer have?
>>>4. What properties should the buttons add ore edit the picture be.
>>>5. What should the click methods of the the buttons that add or edit be?
>>>6. What assignments to I need in add/change button do I need to display the graphics file?
>>>7. How to I display the picture in a report?
>>>
>>>A concrete example would be very helpful and highly appreciated.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
