|Download Help (Windows Only)|
Owning Palette: Database VIs and Function
Requires: Database Connectivity Toolkit
Deletes data from a database identified by connection reference.
|condition specifies an SQL clause that this VI uses to filter the selection criteria. This VI appends this clause to the end of a delete statement. For example, where (col1 > 10). If you wire an empty string to this input, this VI deletes all data from table.|
|connection reference specifies a reference to an ADO Connection object.|
|table specifies the name of the table whose data you want to delete.|
|error in describes error conditions that occur before this node runs. This input provides standard error in functionality.|
|connection reference out returns a reference to an ADO Connection object.|
|error out contains error information. This output provides standard error out functionality.|
Refer to the Database Delete VI in the labview\examples\database directory for an example of using the DB Tools Delete Data VI.