Hi!

Take a look to the FAQ#7995. It is completelys about the binary date and images storing in the remote database from VFP (either using SQL Pass Through, remote views or ADO).

>Currently I use 2 ways to put pictures on SQL server
>1 One through remote view and general field. I make append general and =tableupdate()
> It also return general without possibility to extract in on client
>2 SQLpathrough I read file at client , made decode to ansi, make insert into nchar field
>When I do query to this field, I do back conversion from ansi and write files at all clients
>s
>Is it the 3-d way to use SQLPathough directly with
>image types of the fields without ansi conversion,
>if yes, I would like to see the code
>SQL book on line have some mirical vag words about working with
>such types of the fields and no samples
>Roughly saying, if we had not vFP at all, can we put image directly in query analizerr