post
post
MODE
,
DATABASE
,
KEYFIELD
,
KEYVALUE
,
DATAFIELD
,
DATAVALUE
,
DATAFIELD2
,
DATAVALUE2

The post statement assigns a value to a field in another database.

Parameters

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 you do not use the all option, the post will not work if the specified record is not selected in the target database.
- 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.

Description

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"

Error Messages

Unknown mode in POST – Modes should be listed in the order that they appear above. For instance, “updatesaveall” will not work. It must be “updateallsave”.

See Also

- deletechildren -- deletes all the records in another database that have a value in the key field that is equal to the key value.
- deleterecchildrenwarn -- warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleterecordandchildren -- This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- postadjust -- adjusts the value of a numeric field in another database, by adding (or subtracting) a number.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.