The post statement assigns a value to a field in another database.
This statement has eight parameters:
mode – Controls how post decides which record will be the target.
“update” means that the KeyValue is required to match a value in the KeyField.
“updateadd” (or “addupdate”) means a new record will be added if there is no match for the KeyValue.
“add” means that a new record will always be added. If a KeyField is specified, the KeyValue will be assigned to it.
if “all” is appended to the mode then Panorama will do a SelectAll in the target database before posting the data, for example “updateall”
if “save” is appended to the mode then the target database will be saved after being modified, for example “updateallsave”
database – Name of database you want to post data to. The database must be open.
keyfield – Name of the field you want to search in.
keyvalue – Value you want to search for.
datafield – Name of the field, data will be posted to.
datavalue – Value to be posted.
datafield2 – Name of an optional second field, data will be posted to.
datavalue2 – Optional second value to be posted.
You may post as many data values to as many fields as you wish. They will all be posted to the same record.
This statement assigns a value to a field in another database.
This example assigns the value
"714" to the AreaCode field in the My Contacts database and it will assign
"555-1212" to the Phone field and
"4" to the Ext field. It will look for a matching customer name and create a new record if it can’t find one.
post "updateadd","My Contacts", "CustomerName", CustomerName, "AreaCode", "714", "Phone", "555-1212", "Ext", "4"
|10.0||No Change||Carried over from Panorama 6.0.|