1. Make the SQLTextOverrideSelect property of the data object as 'Partial'
in the Studio.
2. In this_onBeforeExecuteEvent() of the page where this data object is
being used, get the handle to the data object and set the Select part of the
query. ie,
if ( <condition> )
{ selWhatEver = ((CSpSelect) CSpider.getDataObject
("doWhatEverDataObject"));
selWhatEver.setSqlTextSelect(strSelectPartOfQuery);
}
You cannot do anything in dataobject.java
Regards,
Krupesha
-----Original Message-----
From: Kaluza, Isabel SLGA [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 01, 1999 10:26 PM
To: '[EMAIL PROTECTED]'
Subject: [ND] Replace part of select statement dynamically
Hi
My dataobject is
select a, b, c from all
For example in a certain situation in ND 4.1.3 I want in the
dataobject.java
if (situation)
I want to have select a,c from all
How do I do this in my dataobject.java file in the onbeforeexecuteevent??
Isabel Kaluza
Junior Systems Planning Analyst
Saskatchewan Liquor and Gaming Authority
<mailto:[EMAIL PROTECTED]>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
