>>>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!
He just want to know ...
I like general fields. It's better then code obfuscation.
Must have skipped the last around 2000 ..
:D
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.
OffThere is no place like [::1]