ORDER BY using a non-database item? [message #79872] |
Fri, 19 July 2002 10:43 |
Denise Wagner
Messages: 7 Registered: July 2002
|
Junior Member |
|
|
Is it possible to "order by" a non-database item? The item I want to order by is not a part of the base table for the block. I'm populating the item's field using a cursor in a post-query trigger, and the order by statement in the cursor doesn't work.
Thanks for any help,
Denise
|
|
|
|
Re: ORDER BY using a non-database item? [message #80925 is a reply to message #79872] |
Sat, 14 December 2002 09:09 |
samoko Kutchi
Messages: 1 Registered: December 2002
|
Junior Member |
|
|
like sai says, it is not possible if you are not using a programmatic approach. I therefore assume u are. ;-)
You can use dynamic record groups to temporarilly store those items and reorder the record group for your display.
--samoko
|
|
|