Re: Forms 4.5 - Using Order By to order by non base table field

[Quoted] In article <01bc6bea$41fc3be0$4bd8cbc0_at_bobby-bakshi>, Bobby <bobbyb_at_datacom.co.nz> writes
>Hi,
>This is rgds. to using Forms 4.5
>I am trying to use a base table block and order by a field which is a non
>base table field on the same block. I am trying this using the default
>ORDER BY CLAUSE of the block. The block is being populated with an 'Execute
>query' and the non base table field is being populated on the post query.
>
>Is there any way that I can use to order the block by the non base table
>field. The other option is to include the field on the base table and use
>it in the order by clause. But the database design does not let me add this
>field to the table.
>
>I hope someone out ther can help me.
>
>Email - bobbyb_at_datacom.co.nz
>
>Bobby Bakshi.
You probably need to build a VIEW (joining the two tables). This gives you problems with insert/update/delete, so you will then need to do non- -table DML on the original table.

| ~~~~~~~~~~~~~~~~~~~~ | ERIC  HARTZENBERG | ~~~~~~~~~~~~~~~~~~~ |     
| Email    : eric_at_erichome.demon.co.uk   Compuserve  : 100073,21 |
| Homepage : www.erichome.demon.co.uk                            |
|________________________________________________________________|