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.

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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.