Chuck, Actually my original thinking on this was to create a series of arrays containing the external data and another series containing the local data, sorting all arrays by their common field, then displaying the combination.
This seems like a pretty workable solution but I do have some values calculated in On Display Detail that I can change on the fly to display different information. I suppose that I could recalculate a variable array in the background and display the new data without too much of a hassle, rather than using On Display Detail. Sorting would then be very straight forward. Thanks! Alan On Wed, Aug 31, 2016 at 3:34 PM, Chuck Miller < [email protected]> wrote: > Based upon what you are stating, I would use arrays from external source, > build arrays from 4D and display > > If you do it the other way display fields from 4D, you would keep shadow > arrays to fill variables with and yes because you have shadow arrays you > can sort on this columns. I do that now in a variety of places > > I also do not know which approach (array based/ field based) or ALP would > be best for your scenario it depends upon many factors > > Both will do the job for you. I use list boxes and ALP areas in dos, it > just depends upon client and need > > > Regards > > Chuck > ------------------------------------------------------------ > ------------------------------------ > Chuck Miller Voice: (617) 739-0306 > Informed Solutions, Inc. Fax: (617) 232-1064 > mailto:cjmiller<AT SIGN>informed-solutions.com > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D and Sybase connectivity > http://www.informed-solutions.com > ------------------------------------------------------------ > ------------------------------------ > > > > On Aug 31, 2016, at 3:29 PM, Alan Tilson <[email protected]> wrote: > > > > Chuck, > > So you could do one Find In Array to get a row number in the synced > arrays > > and then use that row number to set a series of variables, one for each > > field from the external source. Something like that? But you wouldn't be > > able to sort based upon those columns, correct? > > John, > > Is this something like what you are doing? How do you handle sorting? > > Thanks to you both! > > Alan > > ********************************************************************** > 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] > ********************************************************************** > ********************************************************************** 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] **********************************************************************
