how Set a decimal to NULL

[karl0x]

I tested with string and no problems, but when I do with numbers get error.

Example:

string ls_foo
SetNull(ls_foo)
dw_1.object.datecolumn[row]=ls_foo

OK

decimal ln_foo
SetNull(ln_foo)
dw_1.object.datecolumn[row]=ln_foo

error

Help me....

 

[xsyguy]

Try using the SetItem function instead of a DataWindow data object reference to set the value.

Example:

decimal ln_foo
SetNull(ln_foo)
dw_1.SetItem(row,columnname,ln_foo)

If the column has an Edit Style of Edit you may also need to make sure the "Empty String is NULL" Edit property is checked on.