Making an Integer field empty

Panorama X Beta 10.2
1

I have a procedure that duplicates a record. I want to make sure an integer field in the new record is empty. But I am getting a zero instead of empty when I make an assignment, like this:

[newfield] = ""

Other methods give the same result, such as assign( or assign field(.

But if I select the new record only, and use formulafill, I get an empty field, like this:

field [newfield]
formulafill ""

I would prefer to have a more direct assignment method. Does anyone know how to do this?

2

Use clearcell.

3

Try…

[newfield] = zeroblank(0)
4

Thank you both.

5

Did you consider using the duplicaterecord command?

If you need a version of this that is customized, here is the code that duplicates the record. You could customize as needed. This would eliminate the need to assign each field individually.

unlockrecord
if info("summary")>0
    // beep
    nsnotify "Cannot duplicate record","TEXT","Summary records cannot be duplicated."
    return
endif
let r = exportline()
insertbelow
importline r