We are having the exact same problem after converting our
code to ND4.13.
Does anyone know of a solution to it?
Thanks
Terry Doherty
Ann Smyth May <[EMAIL PROTECTED]> wrote:
>The below code works in ND3, blows up in ND4. Anybody got an idea about>this? Some
>conversion thing we missed? Bug? I believe Ann is running
>4.1.3, on NT4.0 wkstn.
>
>Thanks,
>Curt, Team ND
>_____________________________________________________________________________
>
>Curt- I guess I should send this problem on to tech support. I tried to
>add as much relevant info as possible - I'm not sure what is relevant here
>though. You have any ideas about other things to add? Thanks. -Ann
>
>I receive an error about using sybase cursors even though I specify in
>onBeforeExecuteEvent of the dataobject that the memory table method should
>be used. This dataobject is supposed to populate a listbox but instead it
>shows only one item "None Selected". This code worked ok in ND ver 3.x but
>doesn't seem to work in 4.x. Here's the code in the data:
>
>//[[SPIDER_EVENT<onBeforeExecuteEvent (CSpDBRequest request)>
> protected int onBeforeExecuteEvent (CSpDBRequest request)
> {
> //note - this added by HMS 10/3/96 because default
> //sequential cursor method in native Sybase does not work
> //with this query. In one case, it caused execution to blow up.
> //In most cases, execution proceeded, but it wasted time because
> //ND would first submit the query to Sybase as 'sequential cursor',
> //get an error back, then resubmit it as 'memory table'.
>
> //The call (below) will cause ND to use 'memory table' from
> //the first get-go.
> request.getDBExecuteControl ().setFetchMethod
>(CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);
>
>
>Here is the error in the ND log:
>
>Error 206 DSRdbmsService
>DSRdbmsService:c:923068035132:w:923068037054:SYBASE CUR_KEYSET cursors are
>limited to 1000 rows of data.
>42 Apr 02, 1999 at 10:48:55.465 Warning Thread-8 CPService
>isis.GetSociety:c:923068038667:w:923068038967:triggerDatabaseErrorEvent:
>execution of the DataObject 'GetSociety' has failed:
>43 Apr 02, 1999 at 10:48:55.465 Warning Thread-8 CPService
>isis.GetSociety:c:923068038667:w:923068038967: System error code is 28
>(SYBASE CUR_KEYSET cursors are limited to 1000 rows of data.)
>
>
>In this dataobject just one table is used -"organization" and one field
>-"organization_org_name" with a where statement
>'organization.org_type="SOC" ' The listbox is preloaded in the
>onAfterInitEvent:
>
>protected int onAfterInitEvent ()
> {
> int command = PROCEED_WITH_BUILTIN_HANDLING;
> //fill listboxes once
> cbxsociety_id = (CSpListBox) getDisplayField ("society_id");
> cbxsociety_id.doAutoFill ();
>
>Also, when you use the object inspector on the dataobject GetSociety and
>click on View Data the correct data is displayed.
>
_________________________________________________________________________
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]
