What is the type of ImageFile field? I suspect it is General, isn't it?


>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)
>>