General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Store pictures on SQL server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only