You can't put arrays directly in a selection based listbox, but you can display data from them using a formula column. If you are mixing views with 4D based data, I would definitely use selection based listboxes especially if you want to display large selections.
The arrays you use for the external SQL data don't need to be equal in size to the number of selected 4D records. For example, suppose your selection in 4D is 5000 records. You could start by loading only 1000 rows of SQL data into arrays. If the user scrolls to row 2000, you detect this in the On Display Detail event and fetch the next 1000 rows of data in the arrays. It is possible to implement very smooth scrolling of SQL data without loading huge amounts of data into arrays all at once. John DeSoi, Ph.D. > On Aug 31, 2016, at 1:51 PM, Alan Tilson <[email protected]> wrote: > > John, > I did not realize that array based listboxes did not support formula > columns. > Do selection based listboxes also support arrays? I mean if the data from > the external source is in sorted arrays that are in sync with the 4D > selection, it would be great to just include the array for the column and > for 4D to keep it in sync when sorting, etc. ********************************************************************** 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] **********************************************************************
