The insertfield statement inserts a new field into the database in front of the current field.
This statement has one parameter:
name – is the is the name of the new field you want to create.
This statement inserts a new field into the database in front of the current field. If you want to add a new field at the end of the database, use the addfield statement. The new field is created as a text field. Use the fieldtype statement if you need to convert the new field to a numeric, date, choice or binary field.
This simple example adds a new field called Organization in front of the Address field.
field Address insertfield "Organization"
This example creates a new field called Ratio in front of the Balance field. The procedure converts the new field to floating point, and then calculates values for the new field.
field "Balance" insertfield "Ratio" fieldtype "float" formulafill Price/Cost
|10.0||Updated||Carried over from Panorama 6.0, but no longer supports the `DIALOG` option.|