Changing the Field Type with a procedure

Panorama X Beta 10.2
1

I want to add a field to theTargetDatabase and then set its field type using a procedure. I have tried the following code, which adds the field but does not change the type. (The code is running in a separate database.) Can anyone help?

setactivedatabase "theTargetDatabase"
addfield "ID"
field "ID"
setfieldproperties initializedictionary("TYPE","Integer")
2

Instead of setfieldproperties use fieldtype to change the data type of the current field.

3

That worked! Thanks.