I want to Know as to save and to select in Visual Fox
images(*.BMP) from SQL Server???
Which is the code or tool to save from Visual Fox to SQL
server???
If I can save image in SQL server 2000???

Thanks....

Re: Visual Fox with SQL Server 2000 by Jeroen

Jeroen
Wed Dec 24 18:06:55 CST 2003

On Wed, 24 Dec 2003 13:06:36 -0800, "David"
<anonymous@discussions.microsoft.com> wrote:

>I want to Know as to save and to select in Visual Fox
>images(*.BMP) from SQL Server???
>Which is the code or tool to save from Visual Fox to SQL
>server???
>If I can save image in SQL server 2000???

You can't save an image, but you can save any long string into a
field. If you file this string with the fileinfo from the bmp-file you
can 'save the image'

In foxpro terminology:
lcBMP=filetostr('mylogo.bmp')
replace blobfield with lcBMP

To use it, you have to convert the string back to a normal file:
lcBMP=blobfield
=strtofile(lcBMP,'mylogo.bmp')
_screen.icon='mylogo.bmp'