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', ...]
<a href="default.lasso?-Update&
-Database=Database_Name&
-Table=Table_Name&
-KeyField=KeyField_Name&
-KeyValue=KeyField_Value...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-Update" value="">
<input type="hidden" name="-Database" value="Database_Name">
<input type="hidden" name="-Table" value="Table_Name">
<input type="hidden" name="-KeyField" value="KeyField_Name">
<input type="hidden" name="-KeyValue" value="KeyValue_Name">
...
<input type="submit" name="-Update" value="Update Record">
</form>
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 | Internal | Sets | 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