Hi Tuan,
In ND3, it used to be enough just to change those properties. In ND4, we had
to add the following code to our data objects that return more than 1000
rows:
protected int onDatabaseErrorEvent ()
{
CSpDBResultStatus status = getLastResults().getResultStatus ();
if (status.getErrorCode() == 28)
{
//ND4 bug: cannot handle result set with more than 1000 rows
status.setErrorCode(SUCCESS);
return PROCEED;
}
...
}
We still get an error from RDBMS service in the log when more than 1000 rows
are returned, but everything works fine.
Denis.
> 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]
_________________________________________________________________________
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]
