Ordering text

[Bob Sneidar]

Not enough info but something like:

SELECT SUM(OLD -NEW) as balance FROM some_table WHERE need_to_calc IS true order by balance; (or order by whatever column. Not sure balance is what you are trying to sort by.)

Bob S


> On Mar 29, 2020, at 11:54 AM, doc hawk via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> I haven’t fully followed the queries that led to this, but would something like
> 
> SELECT SUM(OLD -NEW) FROM some_table WHERE need_to_calc IS true;
> 
> get you anywhere?
> 
> 
> I’m also thinking of a lag within the list, to assign them all at once, but the commands coming to memory are from statistical packages, Fortran, spreadsheets,  and other matrix math . . .
> 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode