>I have a table RESIDENT.dbf with picture embedded in a general type field Resimage.
>Command "APPEND GENERAL resimage FROM (picturefile)" is used to embed resident's picture.
>It works pretty good for .BMP pictures. However, .BMP files are much larger than .JPEG files.
>Embedded JPEG images are not displayed on form - just file name
>I tried to convert .JPG into .BMP, but the size of picture file became huge.
>How to use JPEG files in OLEbound image control?
>
>Thanks
>
>Ed
First:
DO NOT EVER USE GENERAL Field type, NEVER!!!!
That is mandatory :-)
When you insert into General field VFP keeps not only file, but the current user default application which handles that kind of files.
I remember we have problems even with BMP, because on my computer I have a Microsoft Imaging installed, but on others only Paint was available.
Just use a CHAR or if the path to picture is very lengthy use Memo, but NOT general.
Do not store picture in the table, keep only path to it.
If your application is multyuser you could copy that picture to a folder where everybodey have access (some subfolder of your data folder)
Then you could use:
thisform.Image.Picture = ALLTRIM(Table.Field)
at every change of the record pointer of your table.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.