Hallo!
What type of field should I use in an SQL-server when I want to save a Picturefile (jpg, bmp, ...))?

I have tried with a fieldtype called "Image" but it dont work. When I do:
SQLexec(nHandle,"select pic from sqltqble","Qtable") from VFP, I get the result in Qtable.pict, and thats a general field.

But if I store the picturefile in a fieldtype called "Text" it will work. Then I get a memofield in VFP after the SQLselect command.

I use the result like this to show the picture in a form:
Thisform.Image.PictureVal=Qtable.pict

But is it right to use the field type "Text" on the server to store pictures? It seems wrong to me.

/Kjell