Julio, http://forums.4d.com/Post/EN/27095796/1
https://bugs.4d.com/fixes?version=16_R2 shows ACI0095714 ODBC driver returns error #9922 if last character in a word is a diacritical sign as è,é or ä (using fields). You would think your version is not susceptible to that because it was fixed in 15.3 HF1 and 16 R2. But it looks like there are other ODBC errors with data getting truncated to 255 characters by some drivers, etc. Is it possible that the data you’re trying to INSERT is causing the SQL statement to exceed some ODBC limitation of the driver you’re using? Randy ---------------------------------------------------------------------- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 Please send all emails to supp...@printpoint.com > On Oct 8, 2021, at 10:37 AM, Julio Carneiro via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > 4d iDoes anyone here know what error 9922 means (not -9922)? this is 4D > v17.5, and I am doing a SQL EXECUTE(“INSERT….“), via a ODBC connection. > Can’t find that error code anywhere, not on 4D docs and not even on 4D Today. > The error only comes up some times, for some statements. > I could not spot any significant difference between “INSERT” that pass and > those that fail. Even to the same table. > > Any link/hints will help > -- > Julio Carneiro > jjfo...@gmail.com > > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************