Rick, sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) is not populating This sqlexec works from the command line in fox but not from the command line in the ww environment Please see below and advise, Best, Deb
Different SQL drivers I'd guess. SQL behavior is different with different drivers...
The varying versions of ODBC drivers support different SQL features - none support all of them so you need to experiment. I tend to stick with the 'old' SQL drivers which seem to work best for support in FoxPro.
The problem is not that the SQL provider doesn't support the data, but that FoxPro can't read the data it returns. Some versions support varchar(max)
others don't. Those that do often don't support text
data or some of the XML features etc. It literally is trial and error.
You can do a search here and see if you can dig up an old thread where several of use reported on various drivers and their support for various SQL features.
+++ Rick ---
Deb,
We had similar issues, and to Ricks point, we were able to resolve them using "ODBC Driver 17 for SQL Server". Downloaded from MSFT 32 Bit for VFP.
Hope this might help.
George ...