[ND] Cursor problem in ND 4.x???

[Kaluza, Isabel SLGA]

Hi 
Does the following need to be done in ND 4.x dataobjects due to Sybase not
supporting type of cursor??
It was implemented in ND 3.x code.  Wondering if still a problem in ND
4.x.????

//Fix for DataObject select failing after firsttime of select
                // even with proper SQL
                int _offset = request.getDBExecuteControl().getOffset();

                // Check here for the large number that is being put out in
the log file

        if (_offset == 999999)
        {    
                request.getDBExecuteControl().setOffset(0);
        }
                        
                //Sybase doesn't support the type of cursor that ND needs,
so it always ends
                //up falling back to a memory fetch. To enhance performance 
                
                request.getDBExecuteControl ().setFetchMethod
                (CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);

                return (PROCEED_WITH_BUILTIN_HANDLING);
        }


Isabel Kaluza
Junior Systems Planning Analyst
Saskatchewan Liquor and Gaming Authority
<mailto:[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]