did you get the solution?
i am also facing the same problem. could you please send the workaround if you
have any.
thanks
suresh
"Mathew, Aby" wrote:
>
> > Hi Les (and Isabel, Jayadev and Suryanarayana) and others -
> >
> >
> > Back to an old thread. Thanks for your suggestions.
> >
> > Unfortunately none of the things have worked so far. (even the ND 3.1
> > method :
> > protected int onBeforeExecuteEvent (CSpDBRequest request)
> >
> >
> > What we have done is :
> > public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
> > { event.getDBRequest().getDBExecuteControl().setFetchMethod
> > (CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);
> > return (PROCEED);
> > }
> >
> > With the help of log messages, we have made sure that this code is being
> > executed. Also confirmed it using getFetchMethod in the
> > onAfterExecuteEvent(CSpDataObjectEvent event).
> > The observations are :
> > No matter what method we set (MEMORY_TABLE_FETCH_METHOD,
> > SEQUENTIAL_CURSOR_FETCH_METHOD etc), we invariably get the following
> > messages from the DSRdbmsService:
> > ===============================================================
> > DSRdbmsService: fetching result table using MemoryTable method
> > DSRdbmsService: fetching all rows -- 1965
> > DSRdbmsService: end-of-fetch: 1965 rows retrieved out of the -1
> > requested
> > DSRdbmsService: end-of-fetch: bounced into first or last row during
> > fetch
> > Error 286 DSRdbmsService: SYBASE CUR_KEYSET cursors are limited to
> > 1000 rows of data.
> > DSRdbmsService: memoryTableFetch: Sybase cursor limit exceeded
> > ==============================================================
> > The last line clearly says: memoryTableFetch: Sybase cursor limit
> > exceed!
> > Any suggestions?
> > Thanks,
> >
> > Aby Mathew
> > (BTW, I am working with Robert Wells on this.)
> >
> >
> >
_________________________________________________________________________
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]
