Delete from ODBC Database

Deletes data from any ODBC-capable database such as MySQL, Microsoft Access, and Oracle databases.

 

Input Arguments

 

0

Connection String

Connection String

The connection string to the database.

1

Table Name

Table Name

The name of the table to access.

2

String

WHERE

A string containing the SQL selection criteria for the data to delete.

 

Return Arguments

None.

 

Returned Status

 

SUCCESS

The data was successfully deleted from the database.

FAILURE

The database or table could not be accessed.

 

Remarks

Unless you know how to format the connection string, the easiest thing to do is to change the entry method to Browse and then click the down-arrow button in the Value field. This opens the Windows ODBC data source picker, which guides you through selecting the proper database.

Unless you know how to format the table name string, the easiest thing to do is to change the entry method to Browse

(once the connection string has been specified) so that you can enter the value using a graphical user interface. For more details on valid SQL strings, search the internet or look into one of many texts on SQL databases.