The -Update command tag allows a record to be updated within a database table.
The database and table for the update action should be specified using the -Database and -Table command tags. The specific record to be updated should be specified using the -KeyField and -KeyValue tags to identify the primary key field and specific key value. Additional name/value parameters specify the new values for the record which is updated within the database table.
[Inline: -Update,
-Database='Database_Name',
-Table='Table_Name',
-KeyField='KeyField_Name',
-KeyValue='KeyField_Value', ...]
Use an [Inline] tag with an enclosed -Update command tag. The following example updates the record with ID equal to 123 within the People table of the Contacts database so the Last_Name field is equal to Newname.
[Inline: -Update,
-Database='Contacts',
-Table='People',
-KeyField='ID',
-KeyValue=123,
'Last_Name'='Newname']
[/Inline]
Tag Link | -Update | Category | Action |
---|---|---|---|
Type | Command | Data Source | Any |
Support | Preferred | Version | 3.0 |
Output Type | None | Security | Database,Classic |
Implementation | LCAPI | Sets | 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 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft