Hmm, a bit confusing ... - "order by" is documented, "order by formula" is not. - 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 - using "order by formula" doesn't throw any error, which might be a hint, that it is implemented though. - 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.
I didn't investigate further with calling a 4D method, as I wanted to use an A4D collection in the search method. 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. Works without impact on the performance although not very elegant from the programmers view. ;-) Peter > Von: Aparajita Fishman <[email protected]> > Antworten an: Active4D Developer Discussion List > <[email protected]> > Datum: Sat, 24 Nov 2012 09:40:18 -0500 > An: Active4D Developer Discussion List <[email protected]> > Betreff: Re: [Active4d-dev] Rowset, Batches and Sorting - best practice > >> One problem with this solution is, A4D seems not to support the "order by >> formula" 4D command. > > It is documented as supported and is in fact supported. Did you try it and get > an error? > > 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/ _______________________________________________ Active4D-dev mailing list [email protected] http://list.aparajitaworld.com/listinfo/active4d-dev Archives: http://active4d-nabble.aparajitaworld.com/
