DB Tools Delete Data VI

LabVIEW 2013 Database Connectivity Toolkit Help

Edition Date: June 2013

Part Number: 370016F-01

»View Product Info

Download Help (Windows Only)

Owning Palette: Database VIs and Function

Requires: Database Connectivity Toolkit

Deletes data from a database identified by connection reference.

Example

	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.

Example

Refer to the Database Delete VI in the labview\examples\database directory for an example of using the DB Tools Delete Data VI.