Hi Prasad,

Put in a third integer parameter after the query string as below :

CSpDataObject.executeImmediate(datasource, sqlquery, maxrowstofetch)

That should work fine. Hope that helps.
Deepak

                -----Original Message-----
                From:   Moganna, Prasad [mailto:[EMAIL PROTECTED]]
                Sent:   Friday, June 04, 1999 10:37 PM
                To:
'[EMAIL PROTECTED]'
                Subject:        [ND] Max Rows in
CSpDataObject.executeImmediate function

                We r using the
CSpDataObject.executeImmediate(datasource, sqlquery) function
                in our
                project. The max no of rows it retrieves is only 1000.
How could I increase
                the no of rows 
                fetched from the database. 

                I tried this setting,
                In my RDBMS Service - worker properties - max records to
retrieve is set to
                5000

                but still I am getting only 1000 rows from the database.

                Could anyone help me out in this.

                Thanks in Advance,
                Prasad
        
________________________________________________________________________
_

                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]

Reply via email to