>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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.