Hi, I have set the Max no of rows to retrieve in the RDBMS service in the Command Center to 7000. But I get only 999 rows ( which is the default ) when I do an executeImmediate(dataSourceName, sqlQuery) Now when I put in another parameter intRows - executeImmediate(dataSourceName, sqlQuery, intRows) the resultset contains whatever I specify for the intRows. This means that the command center setting gets overidden. I want to know if there is any way to achieve the setting done in the command center without specifying anything in the ND code at all ? We want to do this because tomorrow if our table size increases then we shouldn't be going into the code to change things. We should be able to get this reflected just by updating the setting in the command center. Has anybody tried this out ? Thanks, Deepak _________________________________________________________________________ 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]
