Executes an SQL query. This action is useful when you want to update a database. If you want to SELECT from a database, use the Dataset Loop action instead.
Connection String
A string with attribute/value pairs for information required to log on to a database and point to a specific database. Click the browse button to open the Microsoft Data Link Properties dialog box. You can press F1 to access Help about this dialog box.
SQL Query
Enter the query string in SQL syntax.
Variable
Allows you to add a variable to the action or triggering event that you selected. You must place the cursor in a edit box in the settings dialog window of the action or event and then click the {V} button.
Related Topics