Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert address
Message
From
17/07/2011 12:49:27
 
 
To
15/07/2011 20:39:55
Muthu Vel
Sty Company
India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01518328
Message ID:
01518401
Views:
63
IMO, do not inset any picture into data file using blob or general field, your data will be a big size!
Just store picture file location using memo field

This is a simple method:
*!* assume address field is memo
lcPictureFolder = ADDBS("E:\Muthu\address")
USE addresses.dbf IN 0 ORDER  regno
UPDATE addresses SET address=m.lcPictureFolder + TRIM(addresses.regno) + ".jpg"
Regards,
Ony
Regards,
Ony
Previous
Reply
Map
View

Click here to load this message in the networking platform