-KeyValue
-KeyValue specifies the value of the key field which should be used for a database action. This tag must be used in concert with the -KeyField command tag to identify a particular record for a -Delete, -Duplicate, -Image, or -Update action.
The value specified for this command tag can be retrieved using the [KeyField_Value] tag.
FileMaker Note: The -KeyField for FileMaker Pro databases is ignored. The -KeyValue always specifies the value for the implicit Record ID.
- Syntax
- Parameters
[Inline: -KeyValue='KeyField_Value', ...]Examples
To specify the value for the key field in a database action:
Use the -KeyValue command tag. The following example specifies a -Search action in [Inline] ... [/Inline] tags for a record identified by the value 1 in the key field ID.
[Inline: -Search,
-Database='Contacts',
-Table='People',
-KeyField='ID',
-KeyValue=1]
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]Result:
<br>John Doe
<br>John Surname
| Tag Link | -KeyValue | Category | Database |
|---|---|---|---|
| Type | Command | Data Source | ODBC Specific |
| Support | Preferred | Version | 3.0 |
| Output Type | None | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft