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

From: hurd carol <churd1_at_umbc.edu>
Date: 1997/09/04
Message-ID: <5un418$1eh_at_umbc8.umbc.edu>#1/1

Write a stored function, which given some field of the master table, returns the field you want from the detail table, then put the function in your order by clause. It worked beautifully for me!

Carol

>> 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 ?
>>
Received on Thu Sep 04 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: nmk_1970_at_hotmail.com: "How to set passwd for Internal a/c in Oracle"
Previous message: Satar Naghshineh: "Power Objects 2.0 - invalid or missing driver ID for session "Amtec""
Maybe in reply to: Bob Sauer: "Re: Forms 4.5: ORDER BY <column in detail_block>"
Next in thread: Fernando Pereira: "Re: Hints for SQL tuning"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message