Home » Developer & Programmer » Forms » query urgent
query urgent [message #78114] Fri, 18 January 2002 09:20 Go to next message
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/
Re: query urgent [message #78116 is a reply to message #78114] Fri, 18 January 2002 10:42 Go to previous messageGo to next message
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');
Re: query urgent [message #78119 is a reply to message #78114] Fri, 18 January 2002 12:12 Go to previous message
win
Messages: 3
Registered: January 2002
Junior Member
Hi
I tried but i did not get it.

Thanks,
Win.
Previous Topic: Please Help me out!!!
Next Topic: Re: query urgent
Goto Forum:
  


Current Time: Thu Aug 13 06:20:26 CDT 2020