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@
|
