Ok, I'm getting a 'Data Type Mismatch' on the APPEND MEMO line
OPEN DATABASE ImageLoad
IF USED("v_ImageTest")
USE IN v_ImageTest
ENDIF
SELECT 0
USE v_ImageTest
nImageTestKey = 1
cImageName = SYS(2015)
cImageFile = "d:\graphics\test_image.bmp"
INSERT INTO v_ImageTest;
(ImageTestKey, ImageName);
VALUES;
(nImageTestKey, cImageName)
APPEND MEMO ImageFile FROM &cImageFile OVERWRITE
RETURN
>Create SQL-table with Image field. Create VFP remote view (updatable) to this table. Add image to the view (use APPEND MEMO command) and you made it.
>
>>Ok, I looked at Rick's article, and I'm thoroughly lost.
>>
>>Is there a
SIMPLE way to store an image to a SQL table and then
>>retrieve it back to an image on the file system?
>>
>>An example would be great.
>>
>>
>>
>>>>How to I store an image in a SQL table?
>>>
>>>Use the
image data type.
>>>Here is an artice from Code Project to get you started:
>>>
http://www.codeproject.com/aspnet/PicManager.asp>>>Ooops I just noticed that this is the VFP forum (better get my flame suit on)
>>>
>>>Here is a VFP artice by non other than Rick Strahl:
>>>
http://west-wind.com/WebLog/posts/6861.aspx>>>
>>>Einar
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people