LassoScript Utility
Basics Browse Detail

-KeyValue

Tag Link -KeyValue Category Database
Type Command Source Available No
Support Preferred Version 3.0
Change Unchanged Data Source ODBC Specific
Output Type None Security None
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0, Lasso 3.x

Description

-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

[Inline: -KeyValue='KeyField_Value', ...]

Parameters

Required Parameters
KeyField Value The value which should be used to identify a particular record in a database action.

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]

<br>John Doe
<br>John Surname