>Thanks Naomi
>I use BLOB
>but I can't view my image from sqlexec command
>SQLExec(lnHandle,"select * from image")
>browse
>the image field type is General
>It gives error message when I dbl click into the image column
>"OLE object is invalid or corrupted"
>
>
>
>What is the type of the Image column in the MySQL? Did you try
>
>myPicture = filetostr('MyPictureFile.jpg') ?

You need to map the Image to memo binary using setcursorprop function.

See Re: Store pictures on SQL server Thread #1422743 Message #1422754

CURSORSETPROP("MapBinary", .T., 0)