Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL expert.
----- Original Message ----- From: "Richard Kaye" rkaye@invaluable.com To: "ProFox Email List" profox@leafe.com Sent: Tuesday, January 4, 2022 6:37:05 PM Subject: RE: VFP9 and SQL memo fields
Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxtech@leafe.com Subject: VFP9 and SQL memo fields
Happy New Year !!
I have a client trying to upgrade their SQL 2012 server to 2016 but we are having a problem with the TEXT data type only returning 400 characters. We tried to change to VARCHAR(Max) but that returns the same 400 character limit. I am not an SQL expert so I am not sure what is causing the problem, but I suspect it is the ODBC driver we are using??
Has anyone had this problem and found a solution or a new updated ODBC driver that works with SQL 2016?
Thanks, Kent
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]