I don't remember what was actually happening before we added that code. It
was either some kind of error or only the first 1000 rows returned.
> Hi
> I don't understand the below using DataBaseError Event.
> Why does it have to be included?
> Are u saying if Sybase returns more than 1000 rows, only the first 1000
will
> show up on the page??
>
> Isabel Kaluza
> Junior Systems Planning Analyst
> Saskatchewan Liquor and Gaming Authority
> <mailto:[EMAIL PROTECTED]>
>
>
>
>
> -----Original Message-----
> From: Peleshchuk, Denis [mailto:[EMAIL PROTECTED]]
> Sent: Tue Aug 24, 1999 02:23 PM
> To: 'Pham, Tuan A'; 'NetDynamicsDevelopers'
> Subject: Re: [ND] Retrieving max # of rows > 1000
>
>
> 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]
