OraFAQ Forum: Forms » query urgent

Home » Developer & Programmer » Forms » query urgent

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

query urgent [message #78114]

Fri, 18 January 2002 09:20

win
Messages: 3
Registered: January 2002

Junior Member

If any one could help that will be great
There is query form and user query the form by pressing the key F12 Key.
Ok here is way I want.
There is database block say emp_blk and base table is emp.
And there is one mere view let us say emp_view.

When user press F12 key which is to Execute form the query should check for emp_view if the same
Record Exists in it. I want only records which exists in emp_view.

In other sense I want only records which exists in both emp table and emp_view.

Win/

Report message to a moderator

Re: query urgent [message #78116 is a reply to message #78114]

Fri, 18 January 2002 10:42

citrav
Messages: 7
Registered: October 2001

Junior Member

just to make sure that i understand your query correctly

you want to display the records that are common to both the
database block and also another view only

in that case
set the 'where clause' fo the database block during design time
or programmatically to equal the view.field_name. join the two
objects in the where clause

design time

eg. database.field_name=view.field_name

programmatically
set_block_property('block_name',default_where,'join condition');

Report message to a moderator

Re: query urgent [message #78119 is a reply to message #78114]

Fri, 18 January 2002 12:12

win
Messages: 3
Registered: January 2002

Junior Member

Hi
I tried but i did not get it.

Thanks,
Win.

Report message to a moderator

Previous Topic:	Please Help me out!!!
Next Topic:	Re: query urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 04:54:48 CDT 2025