[ND] Retrieving max # of rows > 1000

[Pham, Tuan A]

Hi,
I tried to increase the max number of row limit with the following code:
        public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
        {
                CSpDBRequest request = event.getDBRequest();            
                request.getDBExecuteControl ().setFetchMethod (
                CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);

                return (PROCEED);
        }

AND/OR setting DO property: DefaultMaxRows >1000.
AND setting RDBMS Service - worker properties - max records to 5000
However, I still could not retrieve more than 1000 rows. I'm using Sybase,
what else should I try ?
Thanks,

Tuan Pham
Siemens ICN, Santa Clara
408-492-7808
[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]