It looks like LINK should do the trick.
I wonder if it might help to "empty" the general field first, before you do the APPEND with LINK?

A simple: APPEND GENERAL orders.invoicescan should do that.

Good luck



>Good Day;
>
>How can I embed a LINK to a graphic file into a table?
>
>DETAIL:
>I need to add invoice scans to a very basic bookkeeping system I created a few YEARS ago in VFP6 (recently rebuilt with SP5). In my earliest attempts to do this I had embeded the .JPG into the table, clearly this is a bad idea so I did some research and found the LINK option using append general and created this:
>
> what_file = GETPICT('JPG;GIF', 'Locate Scan 1')
> IF len(alltrim(what_file))>0
> what_file_name=RIGHT(what_file,(LEN(what_file)-RAT("\",what_file)))
> what_new_file=what_scan_path+"\"+ALLTRIM(orderid)+"_"+what_file_name
> COPY FILE (what_file) TO (what_new_file)
> APPEND GENERAL orders.invoicescan FROM (what_new_file) LINK
> ENDIF
>
>and I thought I was done. However, I have noticed the table is getting very large. I did a test and found that infact the table is still increasing in size when I add these scans... so much for LINK.
>
>I like the way the data is represented on my form (see: http://www.commodore.ca/orders.jpg ) but for obvious reasons I need to have the database LINK to the scans, not EMBED the scans.
>
>Any assistance would be greatly appreciated.