I think this is only a problem with ND and Sybase. It seems like a ND4 bug
to me because our code worked fine in ND3 without catching any data object
errors. Anyway, if you add this code, you should be able to retrieve more
than 1000 rows.
> Denis,
> Do you mean it's ND4 bug not to be able to get result set > 1000 rows? And
> that's why you checked for error ?.
> Thanks
>
> 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]
_________________________________________________________________________
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]
