|
|
|
|
| Re: difference between onetime_where and default_where? [message #381149 is a reply to message #381031] |
Thu, 15 January 2009 07:46   |
|
|
Hi,
As much I know
we use it for selecting data in master table which is not in child table
it reset the blocks with a where clause after the query.
You will store the current value of the DEFAULT_WHERE on the block, and then reinstate it once your query has completed.
If you're using forms 9i you can use ONETIME_WHERE.
Write Trigger on Pre_query of child bolck
begin
Set_Block_Property('Child Block',ONETIME_WHERE,'child_block.item IN (SELECT ..FROM table where ....);
end;
as i 've also never encountered a case to use of this feature so i think you should wait for Experts Advise...
Javed
[Updated on: Thu, 15 January 2009 07:47] Report message to a moderator |
|
|
|
| Re: difference between onetime_where and default_where? [message #381220 is a reply to message #381149] |
Thu, 15 January 2009 21:25 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Please use the reference manual as a guide.
| Oracle9i Forms Developer, Reference Guide | Any WHERE condition specified in the ONETIME_WHERE clause is appended to the query for the next execution only, i.e is a throw-away addition to the WHERE clause.
|
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
