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" <rk...@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-boun...@leafe.com> On Behalf Of kbe...@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxt...@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] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2144591175.101102642.1641347256082.javamail.zim...@mchsi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
