I do stand corrected however, as I got the dgdata of a grid with 6 records, in the order they were added to the sql database, and then queried for. The keys are NOT in numerical order:
5 6 1 2 3 4 I have never wrapped my head around why that is! Bob S > On Aug 7, 2018, at 15:12 , Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com> wrote: > > You can as I understand get the keys of an array, which returns a string, > then sort the string. I am unaware of any function that can sort an array > natively before it is returned. > > Bob S > > >> On Aug 7, 2018, at 15:02 , Richard Gaskin via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> Bob Sneidar wrote: >> >>> Someone said, probably Mark, that numbered key arrays beginning with 1 >>> will always return their keys sorted numerically. I always wondered >>> why almost every other array seemed to scramble to order of it's keys, >>> but datagrid arrays never did. >> >> Associative arrays are a collection of hashes, and as such have no internal >> sense of order. >> >> The DataGrid script runs output through the sort command before returning it. >> >> -- >> Richard Gaskin >> Fourth World Systems >> Software Design and Development for the Desktop, Mobile, and the Web > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode