
November 19th, 2004, 07:02 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 11
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Quote: | Originally Posted by rupas  Hi Friends!
I am facing some problem with DEFAULT_WHERE. My problem is I am passing some parameters from one form to another form. After I get the parameters in the second form and if I use the parameters in the block property(i.e., at WHERE clause, the code I wrote is : ONL_DATE BETWEEN :PARAMETER.START_DATE AND :PARAMETER.END_DATE AND ONL_USER_ID = :PARAMETER.USER_NAME
AND ONL_TAB_NAME = :PARAMETER.TABLE_NAME ) and
it is working fine and showing the results. But for some reasons I want to set the default_where condition explicitely. So I am using SET_BLOCK_PROPERTY. I wrote this at WHEN_NEW_FORM_INSTANCE and is like this.
SET_BLOCK_PROPERTY('DW_APP_AUDIT',DEFAULT_WHERE,'ONL_DATE BETWEEN '||:PARAMETER.START_DATE|| 'AND '||
:PARAMETER.END_DATE||'AND ONL_USER_ID = '||:PARAMETER.USER_NAME||' AND ONL_TAB_NAME = '||
:PARAMETER.TABLE_NAME);
When I check Message('Where Condn is : '||DEFAULT_WHERE) then it's showing me '190'. I don't know where this '190' is coming from.
Pls help me how to set the DEFAULT_WHERE and solve this problem as it is very urgent.
Thanks |
U get any FRM error or can u attach a screen-shot of the same...
|