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]
