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]