insertfield
NAME

The insertfield statement inserts a new field into the database in front of the current field.


Parameters

This statement has one parameter:

name – is the is the name of the new field you want to create.


Description

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

See Also


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but no longer supports the `DIALOG` option.