How to update a General field?

[shelbytll]

How do I modify a General field in a table?
I have an image in the general field already.
If user want to update the image?
How do I update?
Is it: Append General field1 from &filename ? I am a clever newbie...

 

[ChrisRChamberlain]

shelbytll

'How do I modify a General field in a table?'

One of the limitations of using a general field to store an image is that you will only be able to modify that image with the Windows graphics editor associated with that file type.

You need an OleBoundControl on a form with the general field as its control source - double clicking on the control will activate the Windows graphics editor to enable the user to edit the image.

Anothe limitations of using a general field is that there is no

COPY GENERAL fieldname ...

as there is

COPY MEMO fieldname TO path\filename.ext

so you can't copy the general field to disk and let your user modify the file with a graphics editor of their choice.

'How do I update?'

Append General field1 from &filename

You would be wise to rethink your strategy for this project - you have chosen the least favoured option to handle graphics files.

You will find very little support for the use of general fields to store images in this forum.
HTH

Chris