On 2/23/06, sk2001de <[EMAIL PROTECTED]> wrote:
>
> > A while ago I added a hack to order the columns, and since we
> > never figured out a better way, it's still in there. Right-click on
> > the *label* for the column on the select page, and you'll get a
> > context menu that will allow you to sort on that column.
>
> Sorting the data after doing the query doesn't really help. I have a
> table to which entries are continuously added, including a timestamp.
> Since the table will grow quite large, it is not desirable to query
> all entries at once, but instead the user wants to see the, say, 100
> latest entries. So the SQL statement should look like
>
You misunderstood: the sort is done on the Select page, *before* the query
is run. Do this: open the app, and before you run any query, right click on
the labels next to the sort selection controls. You'll see a context menu
that will let you sort on that field. Try it, and let me know how it works
for you.
--
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://dabodev.com/
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
