Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Image processing
Message
From
01/04/2015 04:58:28
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
01/04/2015 03:31:58
Muthu Vel
Sty Company
India
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:
01617576
Views:
35
>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.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform