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.