A table has 1091 records. In this table, there are 971 records whose column named 'period' contain an empty string (''). The following find/search code is used to extract the 971 records (numbers verified using SQL Explorer):
- Code: Select all
var fs = databaseManager.getFoundSet( databaseName, tableName )
if ( fs.find() )
{
fs.period = ''
var recordCount = fs.search()
<remainder of code>
}
The variable 'recordCount' always returns a value of 200. Should it not be returning the number of records found (971)?
Any help or suggestions appreciated...thanks!