Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 19th, 2004, 01:15 AM
rupas rupas is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 4 rupas User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Problem with Default_Where !!!! Urgent !!!!

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

Reply With Quote
  #2  
Old November 19th, 2004, 07:02 AM
J@oracle J@oracle is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 11 J@oracle User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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...

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Problem with Default_Where !!!! Urgent !!!!


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT