> - "order by" is documented, "order by formula" is not.
Well, if you read past the first paragraph of the "Command Reference" chapter, it says, "Following is a list of the 4D commands implemented by Active4D." And on the next page, there is a list entitled "4D Commands Supported by Active4D", which includes ORDER BY FORMULA. > - in sublime with your a4d bundle only "order by" is color coded in "order > by formula", which seemed to confirm that "order by formula" is not > implemented The Sublime Text package cannot be considered the definitive source for anything. > - I've only tried to call an A4D method in "order by formula" and that > didn't work. The method is not called at all, no error, not effect on the > sort order, just like the "order by formula" statement was not called. There is the problem. I support 'order by formula' but underneath 4D is actually doing the work, therefore you have no access to Active4D methods, local variables, collections, etc. > Finally did it "old style" by loading > the record numbers of the selection into an array, sorted this according to > another array build from the collection and reloaded the selection from the > record number array. I suppose I could support a version of 'order by formula' that is executed within Active4D. Internally it would use the technique you used. The disadvantage is if it executed on Remote, it is executed on Remote and potentially will have to load every record in the selection. Regards, Aparajita www.aparajitaworld.com "If you dare to fail, you are bound to succeed." - Sri Chinmoy | www.srichinmoy.org _______________________________________________ Active4D-dev mailing list [email protected] http://list.aparajitaworld.com/listinfo/active4d-dev Archives: http://active4d-nabble.aparajitaworld.com/
