Insert & Read image in SQL Server

[Qamar Zaman]

Hello experts,

i am using front end VFP9 and back end SQL Server 2014.

1. how to insert or update image file in sql server table. which type use in sql server table for image.

2. how to read or show image file on vfp form.


Thanks in advance
Qamar Zaman

 

[GriffMG]

The file could be stored in a varbinary(MAX) field.

To get it in there, you would need a parameter for the SQL call - you can't put the contents of a file into a string comfortably - that would look a bit like this:

Update tblMyTable Set FileName=@FileName, ImageFile=@ImageFile where ID = myID;

You would probably want to store the original file name or at least the file type along with the actual file so you know what it is later.

You could usefully explore this thread, Olaf has made a good contribution to it.

thread184-1675028

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Qamar Zaman]

Right Griff

Thank your so much ...

Regards,
Qamar Zaman