Re: Order by non-base table fields
From: DanHW <danhw_at_aol.com>
Date: 24 Jun 1998 01:31:37 GMT
Message-ID: <1998062401313700.VAA16837_at_ladder03.news.aol.com>
Date: 24 Jun 1998 01:31:37 GMT
Message-ID: <1998062401313700.VAA16837_at_ladder03.news.aol.com>
>I have a simple block with some none base-table fields. I want the
>records in the block to be ordered by one of the non-base table fields.
>How can I do it ?
>
>Fred Jougin
How is the non-base column getting filled? it sounds like every row returned would have the same value, so any kind of order by would have no effect.
That said, you can use form parameters and globals to generate the order by clause at runtime, and use the SET_BLOCK_PROPERTY function to set the ORDER_BY for the block. Set it in the PRE-QUERY trigger.
Dan Hekimian-Williams Received on Wed Jun 24 1998 - 03:31:37 CEST