This is one way to do it in ND4, during the data object's
onBeforeExecuteEvent which is passed an event. In ND3, the same event is
passed the request, so it's a step easier.
//[[SPIDER_EVENT<this_onBeforeExecuteEvent>
public int this_onBeforeExecuteEvent(CspDataObjectEvent event) {
CSpDBRequest request = event.getDBRequest();
request.getDBExecuteControl().setFetchMethod(
CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);
Thanks,
Paul Gentile
_______________________________________________________
Cardinal Group International, Inc. 508 620 9119x170
495 Old Connecticut Path [EMAIL PROTECTED]
Framingham, MA 01701 www.cardinalgroup.com
-----Original Message-----
From: Howarth, Dan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 29, 1999 1:28 PM
To: NetD Forum (E-mail)
Subject: [ND] executeImmediate Problem
I need to set the FetchMethod to MEMORY_TABLE_FETCH_METHOD for
the following executeImmediate query but don't understand how to code it:
CSpDBResult results =
CSpDataObject.executeImmediate("DsMeasurement",
"select CONVERT(CHAR(10),LOGIN_TIMESTAMP,101), CUSTOMER_ID, COUNT(*)" +
" from Web_Account_Login" +
" group by CONVERT(CHAR(10),LOGIN_TIMESTAMP,101), CUSTOMER_ID",10000);
We're using Sybase which requires us to use the MEMORY_TABLE_FETCH_METHOD. I
have this working fine with normal data objects but this is first time I've
needed to use
an executeImmediate. Can someone please help me with a code example.
Thanks.
.
PG&E Gas Transmission Texas and any other company referenced herein which
uses the PG&E name or logo are not the same company as Pacific Gas and
Electric Company, the California utility. These companies are not regulated
by the California Public Utilities Commission, and customers do not have to
buy products from these companies in order to continue to receive quality
regulated services from the utility.
_________________________________________________________________________
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]
