oh, i love this topic. this onion is so, so thick.
since you are throwing in the curveball of on-demand column sorting, i have
several suggestions (and these are just my suggestions):
the obvious one is to use one of the bajillion ways that LC can sort,
right? grab the data (if you don't already
So what if you use the column headers on a PolyGrid (or whatever) to
give the user a UI for sorting by column (adding, or not, sort arrows to
the header labels).
Is it still more efficient to re-query the database with the new, user
chosen, sort order and repopulate the PolyGrid?
Or more
Not sure how that happened. If the source is a DATABASE...
On Aug 25, 2022, at 08:02 , Bob Sneidar via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
+1 if the source is a dabs, sort during query.
Bob S
___
use-livecode mailing list
+1 if the source is a dabs, sort during query.
Bob S
On Aug 25, 2022, at 07:21 , Mike Kerner via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
it will probably be faster and more flexible to have your database do your
soriting for you, though.
On Mon, Aug 15, 2022 at 7:47 PM
it will probably be faster and more flexible to have your database do your
soriting for you, though.
On Mon, Aug 15, 2022 at 7:47 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:
> Perhaps some expansion of the column "pgContentTypeofColumn" property?
> The current
Perhaps some expansion of the column "pgContentTypeofColumn" property?
The current possible values are:
text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
Allowing the addition of 'numeric' and 'datetime' would at least allow a
mapping to sorts although sort support 'international'
Datagrids have this feature, so yes, I would expect there to be some way to
specify what kind of sort you want to do. But it would have to be on a per
column basis.
But if you are sorting the text yourself, you can use the syntax: sort lines of
tText by item n of each.
I don't think any
So it occurred to me, while playing with sorting by columns, that it
might be nice to have an additional "sortType" available.
I'd like to be able to say
- if all the 'things' being sorted on are numbers, then sort numeric,
otherwise sort alphabetical.
Would that be a reasonable
