I second Chuck’s comment about 4D -> SQL Server via ODBC being much easier, stable etc than SQL Server -> 4D via ODBC. I know that probably doesn’t help, but if you have the option to change your architecture it would make life much easier.
Tom Benedict > On Oct 3, 2019, at 10:22, Charles Miller via 4D_Tech <[email protected]> > wrote: > > can we see the entire sql statement you are using. What version of 4D? > > Lastly, If you can I have always found it easier to go from 4D to sql > server. If you are on PC you already have odbc on PC if on mac you > would have to buy odbc driver for sql server. I always use the one > from actual technologies > > Regards > > Chuck > > On Thu, Oct 3, 2019 at 12:56 PM Paul Jones via 4D_Tech > <[email protected]> wrote: >> >> We pull data from 4D into MS SQL using the 4D ODBC Driver. On occasion, we >> have a problem with some Alpha fields where only the first 2 characters are >> pulled into SQL. >> >> ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
