The setpermanentvariable statement sets the value of a permanent variable in another database. The database must be open. An empty value will choose the currently active database.


This statement has three parameters:

database – the name of the database that contains the permanent variable.

variable – the name of the permanent variable. Since this is the name of the variable, and not the variable itself, you usually need to quote the name (unless you are somehow calculating it with a formula).

value – the value to be placed into the permanent variable.


This statement changes the value of a permanent variable in another database. If the variable doesn’t already exist, it will be created. This example sets the HomeZipCode permanent variable in the Contacts database to 91209.

 setpermanentvariable "Contacts","HomeZipCode","91209"

Note: This statement is extremely fast, and sets the value without temporarily switching to the specified database. Remember also that the new value of the permanent variable will not be retained unless the file containing it is saved before closing.

See Also


10.0NewNew in this version.