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]