| 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/
|
|
|
|
| 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');
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
