What is the type of ImageFile field? it should be 'blob'. Also you don't need macro substitution in this case

APPEND MEMO ImageFile FROM (cImageFile) OVERWRITE

>Sergey, I'm using this to try place an image into the SQL table. I'm getting a Data Type Mismatch on the APPEND line.
>
>Any idea what's wrong here?
>
>
>

>
>OPEN DATABASE ImageLoad
>
>IF USED("v_ImageTest")
>	USE IN v_ImageTest
>ENDIF
>
>SELECT 0
>USE v_ImageTest
>
>cImageName = SYS(2015)
>cImageFile = "d:\projects\pmis\version8\vfp9\source\graphics\test_image.bmp"
>
>INSERT INTO v_ImageTest;
>	(ImageName);
>	VALUES;
>	(cImageName)
>
>APPEND MEMO ImageFile FROM &cImageFile OVERWRITE
>
>RETURN
>

>
>