updating a column with nulls using foundsetupdater

Classic Servoy
1

I use the following method to update a column with the value to be used passed as a parameter to the method:

//resetInterimBillStatus[maBillingInterim]
var updater = arguments[0]
if ( ! updater )
{
controller.loadAllRecords()
}
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
fsUpdater.setColumn(‘interimbillstatus’,updater)
fsUpdater.performUpdate()

The method works perfectly when there is a value passed, however, when the value is null, I want to clear the entire column of all records in the table. What happens is all records are found, but the column is not updated. What am I doing wrong?

2

yes found a problem when you update a column to null and there is no where part. Fixed this for the next build >2.2rc2

3

Thanks!