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', ...]
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 | LCAPI | Sets | Lasso 7.0, Lasso 6.0, 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