Just use: CSpDataObject.executeImmediate( "MyDataSource", "SELECT * FROM Table", 
MaxNumOfRows );

Harry Lamer

"Moganna, Prasad" <[EMAIL PROTECTED]> wrote:
>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]

Reply via email to