Re: [FORMS3] sorting after query
Date: 3 Dec 1994 22:52:58 GMT
Message-ID: <3bqssa$4d7_at_news1.delphi.com>
cit (cit_at_cityscape.co.uk) wrote:
: Perform a query and bring back some rows sorted on an identifier for a
: person. The POST-QUERY trigger then populates the person name field on
: the form (this is a non-table based field - trigger just gets data from
: the person table). What I want to do is sort on this surname. The form
: has a master-detail relationship which brings back the person ids which
: for this relationship are sorted not in the person table but A.N.Other
: table. I know how to do this in a PRE-QUERY trigger but do not want to
: redesign the form.
: UK
That's a tricky one. The first thing I'd try would be something like this in the wherre/order by field in the block definition page:
order by select last_name from more_people_info b where b.id = :block.id
There's no guarantee this is allowed; I'm not where I can try it out. I didn't want you to think nobody was listening, though! Received on Sat Dec 03 1994 - 23:52:58 CET