OraFAQ Forum: Forms » Order By something outside the current database block

Home » Developer & Programmer » Forms » Order By something outside the current database block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Order By something outside the current database block [message #86061]

Thu, 26 August 2004 10:07

Tim Boyer
Messages: 4
Registered: August 2003

Junior Member

Forms 6i

My main database block has a forien key to another table. Table B contains the VarChar2 description of this key.

I have tried to create a master-detail relationship to Order my main database block by the description in Table B. The Order By of my main database block is not accepting the description item from the other block.

I have tried to create a Program Unit Function on my form that will fetch the description from Table B. Then I modified the Order By of my main database block to call the function and I get a FRM-40505, unable to perform query.

Any help would be appreciated.

Report message to a moderator

Previous Topic:	unable to see Scrollbars in forms MDI at resolution 800* 600
Next Topic:	QUERY IN MATRIX FORM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 23:07:39 CST 2025