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. Thank you, Alan
Kirk, I'm not sure what part of my situation your proposal is for? Alan On Tue, Aug 30, 2016 at 8:18 PM, John DeSoi <de...@pgedit.com> wrote: > > > On Aug 30, 2016, at 3:48 PM, Alan Tilson <alantil...@gmail.com> wrote: > > > > Most of the time there is a matching 4D table but there could also be > times > > where all the data is coming from an external source, so I suppose I am > > talking about array based listboxes. > > It takes some work, but selection based listboxes work well for displaying > large result sets from external databases. I use this all the time with > Postgres. You need a "dummy" table to create a record selection with the > number of rows in the result set. A table with a single boolean field is > all you need. You can use the On Display Detail event to cache just a > subset of the data needed to display the visible rows. > > It would be really nice if array based listboxes supported formula columns > and the on Display Detail event. Then all you would need to do is create a > boolean array with the right size and manage data fetching for the visible > rows. > > John DeSoi, Ph.D. > > > ********************************************************************** > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************