Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GENERAL FIELD Question
Message
From
01/12/2002 15:48:22
Ian Matthews
Up & Running Technologies Inc
Chestermere, Alberta, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
GENERAL FIELD Question
Miscellaneous
Thread ID:
00728492
Message ID:
00728492
Views:
50
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.
Next
Reply
Map
View

Click here to load this message in the networking platform