Web Connection
sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
Gravatar is a globally recognized avatar based on your email address. sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
  Debra Froonjian
  All
  Mar 29, 2022 @ 06:27pm

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

Gravatar is a globally recognized avatar based on your email address. re: sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
  Rick Strahl
  Debra Froonjian
  Mar 30, 2022 @ 01:30pm

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 ---

Gravatar is a globally recognized avatar based on your email address. re: sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
  George
  Debra Froonjian
  Apr 5, 2022 @ 11:55am

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 ...

Gravatar is a globally recognized avatar based on your email address. re: sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
  Debra Froonjian
  Debra Froonjian
  Apr 6, 2022 @ 11:32am

Thank you Rick and George!!!

I will let you know how we decide to proceed

Best, Deb

Gravatar is a globally recognized avatar based on your email address. re: sqlexec(lnapihandle,"select * from blpdf where bol_num = '0407'","blpdf") field type varbinary(MAX) not populating
  Debra Froonjian
  George
  Apr 18, 2022 @ 08:45pm

Thank you Rick and George!!

The ODBC Driver 17 for SQL Server works every time!!!

Best, Deb

© 1996-2022