Looks like the limiting factor is the number of lines in the scrollable text area. I did verify that all the data is in the variable. If I resize the text area to be smaller so there's a lot of word wrapping (and extra lines), the data gets truncated. If I widen the area so each SQL statement is on its own line with no word wrapping, I can scroll to the end and see all of the data.
Also, if the data is truncated in the display, you can still do a select all/copy and all of the data ends up in the clipboard. Thanks all for the ideas... -- Jeffrey Kain [email protected] > On Feb 14, 2017, at 10:50 AM, Thomas Maul via 4D_Tech <[email protected]> > wrote: > > The documentation does not describe the length in detail, as it depends from > OS (Mac/Win) and from the OS version. > Last time I tested it was 100.000 on Windows 10 and 1 Million on macOS 10.11 > (with 4D v15.1). Could be more/less on other systems, versions. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

