Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Image processing
Message
From
01/04/2015 07:41:04
 
 
To
01/04/2015 04:58:28
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01617575
Message ID:
01617583
Views:
28
>>I have Printing.dbf having fields with 1. Regno(I), 2.(Category(C), 3. Rank(I) 4. address(M). I have student address in Image format i.e JPEG. I use below code to store the image in my address field but I have got error message.
>>
>>code
>>lcpicturefolder = ADDBS("E:\Muthu\studentaddress")
>>use printing AGAIN IN 0 ORDER regno
>>Update printing set address = filetostr(addbs(m.lcpicturefolder) + LTRIM(str(printing.address))7 + ".jpg")
>>
>>How to store the image in vfp table?
>
>
>My general advice is not to store the pictures inside DBF
>
>My idea is creating a subdir to the place where the dbf is, copy the files there and store the location of the copy.
>
>-no bloat of DBF/FPT
>-no problems with limits of DBF/FPT file size
>
>If you realy need to put it into a DBF you can use the BLOB type and the GENERAL type, MEMO BINARY is an other way.

Just a warning! Stay away from general fields. At all cost!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform