Deletes data from any ODBC-capable database such as MySQL, Microsoft Access, and Oracle databases.
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. |
None.
SUCCESS |
The data was successfully deleted from the database. |
FAILURE |
The database or table could not be accessed. |
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.