Re: Forms 4.5: ORDER BY <column in detail_block>

Walter Zimmer <see_at_signature.for.email.de> wrote
> Hi !
>
> I have a problem which has - I believe - no solution in Forms 4.5:
>
> I have two blocks, one master with computers and one detail with
> network interfaces. I need this because every computer can have
> several network interfaces. The detail table contains also the
> IP-addresses, and now the question arises:
>
> How can I query the master block, but ORDER BY according to the
> IP-address ?

1. You are right, this cannot reaaly be done in FORMS.
2. Might I suggest you have a word with your DBA or Datbase designers. If the value is the same in all detail records for one master, then it should BE in the master record (if not the same, then sorting the master on it would be meaningless). The only reason for putting it in the detail record would be if denormalising for performance reasons, and then it should be in BOTH records.

--
The above posting represents the personal opinions of the author and
is not to be taken as official (or unofficial) policy or opinions of 
his employer.

Remove XSPAM from mail_id if replying via email.
Alex Heney, Living in the Global Village.