>From what I know, ND4 has no problem in fetching more than 1000 rows
from Sybase. But it somehow feels something has gone wrong and gives an
error message (error code 28) and stops processing. If you override
onDatabaseErrorEvent() and tell ND its okay, nothing to worry, then life
goes on.
Aby
-----Original Message-----
From: Pham, Tuan A [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 24, 1999 1:36 PM
To: 'Peleshchuk, Denis'; 'Pham, Tuan A'; 'NetDynamicsDevelopers'
Subject: Re: [ND] Retrieving max # of rows > 1000
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
-----Original Message-----
From: Peleshchuk, Denis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 24, 1999 1: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]
_________________________________________________________________________
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]
