The -Delete command tag allows a record to be removed from a database table.
The database and table for the delete action should be specified using the -Database and -Table command tags. The specific record to be deleted should be specified using the -KeyField and -KeyValue tags to identify the primary key field and specific key value.
[Inline: -Delete,
-Database='Database_Name',
-Table='Table_Name',
-KeyField='KeyField_Name',
-KeyValue='KeyField_Value', ...]
<a href="default.lasso?-Delete&
-Database=Database_Name&
-Table=Table_Name&
-KeyField=KeyField_Name&
-KeyValue=KeyField_Value...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-Delete" 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="-Delete" value="Delete Record">
</form>
Use an [Inline] with the -Delete command tag. The following example deletes the record with 123 in the ID field from the People table of the Contacts database.
[Inline: -Delete,
-Database='Contacts',
-Table='People',
-KeyField='ID',
-KeyValue=123]
[/Inline]
Tag Link | -Delete | Category | Action |
---|---|---|---|
Type | Command | Data Source | Any |
Support | Preferred | Version | 2.5 |
Output Type | None | Security | Database,Classic |
Implementation | Sets | Lasso 5.0,LDML3x,LDML25 |
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