Re: [FORMS3] sorting after query

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