Lasso Soft Inc. > Home

-Delete

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.

  • Syntax
  • Parameters
[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>
Examples

To delete a record from a database:

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. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft