Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending a JPG into a general field
Message
 
To
03/01/2007 15:38:25
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01181794
Message ID:
01181991
Views:
8
So he needs to convert JPGs to BMPs on the fly, then APPEND GENERAL, then .... ;)

Thanks, i missed that. I just want to see if code that works here does/doesnt work there. He was pointing to F drive files and i didnt see any IF FILE commands prior to appending. Granted he may be doing that, but suggest starting w/ simplistic stuff just to rule stuff out. he also mentions 'file size' error msgs, thats why i suggest small files... just to rule stuff out. It definately is strange. Did he mention that he DOES have a program associated with JPG files?

>Bmp will work with no problems. It's Jpg that creates problems.
>
>>For kicks, try the following code to see if the appended file makes it into the gen field. point to a small file when u do the import. and make sure its a file on your C drive... just to test. I am pointing to a windows bmp under WINNT. Try a BMP and a JPG.
>>
>>
CREATE TABLE TempGnrl FREE (tp_dummy C(1), tp_general G)
>>INSERT INTO tempgnrl (tp_dummy) VALUES ("X")
>>APPEND GENERAL tempgnrl.tp_general FROM "C:\WINNT\soap bubbles.bmp" LINK
>>BROWSE
>>
>>>No, I'm trying to use the GENERAL method because the other way isn't working.
>>>
>>>Thank you all for the suggestion not to use APPEND GENERAL if possible, but that ship has already sailed. Could someone please answer the original question, as how to actually save a graphic to the general field?
Previous
Reply
Map
View

Click here to load this message in the networking platform