Still getting 'Data Type Mismatch'
>>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
>
>
>Change
>
>APPEND MEMO ImageFile FROM &cImageFile OVERWRITE
>to
>REPLACE ImageFile WITH FILETOSTR(cImageFile)
>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people