[pilot-db-list] Re: Sorting Times and Dates

[Tom V. <tw...@ss...>]

I don't have any trouble sorting on time- or date-stamp fields in the 
latest version. I thought perhaps this was an ASCII sort issue, since I 
have set my date format in Palm-Prefs to YY/MM/DD, which should sort 
the same ASCII or integer. But it worked fine regardless of date 
format.

I use DB all the time now, and it works fine on my Clie (sigh). The 
most complicated database I have calculates my gas mileage based on a 
fuel purchase log (it accumulates non-fill-ups and updates the MPG at 
fill-ups). Some usability tweaks would be nice, to eliminate some 
redundant tapping.

As for sorting on multiple fields, you can bring up the Sort dialog 
(command-S), then tap on the leftmost drop-down to "insert-after" to 
get more than one field showing. Specify the desired sort fields with 
the right-hand drop-downs.

The way I do it is with a Global Script. You may have read that the 
"(sort 0 1)" directive will sort on field 0 ascending. But you can also 
say "(sort 0 1 1 1)" to sort first on field 0 ascending, then for 
records with equal field 0 sort again on field 1 ascending. To resort, 
just re-execute the global script.


        twv@