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]