Deleting Field Data in a script

Classic Servoy
1

Im not having much luck trying to script the deleting of a colmn of data.

//loop to delete all amount numbers
var totalCount = controller.getMaxRecordIndex(); // == currentFoundCount
for(var i=1; i<=totalCount; i++)
{
controller.recordIndex = i;
amount = “”;

};

the amount column is an int. I would like to just empty to NULL or blank if posible. Any suggestions?

2

try amount = null

3

that worked perfectly. thanks a bunch.