Re: ordering a tabular in a form

Originally posted by Drukqs
> Daniel Morgan wrote in news:3EC6AB55.11665F12_at_exxesolutions.com-
> :news:3EC6AB55.11665F12_at_exxesolutions.com:
>
> > So where is the code? What trigger? And how does it relate to
> the
> > EXECUTE_QUERY for that block?
>
> As I said it's a when-button-pressed trigger. I am just testing
> this. So I
> have only 1 form with those 2 fields as desribed in my first
> example. I
> execute the query manually (just testing). And the I get the tabular
> ordered by postal code. Now if I push the button I want it to be
> sorted by
> city. That's not so hard to understand I think. And it doesn't
> work here. I
> only have this piece of code in the trigger.
> set_block_property('city',order_by,property_true)
> So maybe some advice?
> Thx

The way to set the order by for a block in Forms is:

set_block_property( 'blockname', order_by, 'itemname1,itemname2' );

So if your block is called 'B' then your code should be:

set_block_property( 'B', order_by, 'city' );

At the moment you are setting it to order a block called 'CITY' by a constant value PROPERTY_TRUE, which happens to have the value 4! You should therefore get the error:

FRM-41056: Cannot find Block: invalid ID.

--
Posted via http://dbforums.com