omron — DBDelete

Appendix: Built-in Scripting Language Note: This feature emulates SQL (Structured Query Language) database operations. You should be familiar with how SQL commands are formed and executed before you use this feature. Description Gets the total number of rows in a SQL result set. See also DBCursorColumnCount() . Syntax DBCursorRowCount( numCur , " optStrErrorTag " ) numCur The cursor handle of the result set. The cursor handle is returned by DBCursorOpen or DBCursorOpenSQL . optStrErrorTag The name of a String tag that will receive detailed error messages, if errors occur during runtime. Note:

The tag name must be enclosed in quotes, as shown in the syntax diagram, or else the project will try to get the value of the named tag. This is an optional parameter. Returned value Returns the number of rows. In case of error, returns a negative number. Notes See also DBCursorColumnCount . Examples As used in a Math worksheet: DBDelete Deletes selected rows from a database table. (This function is equivalent to a SQL DELETE statement.) Note: This feature emulates SQL (Structured Query Language) database operations. You should be familiar with how SQL commands are formed and executed before you use this feature.

Syntax DBDelete( strDBConn , strTable , strCondition , " optStrErrorTag " ) strDBConn strTable The name of the database connection. Connections are configured in the Database/ERP folder. The name of the table in the database. strCondition A string that specifies which rows of the table to select. This is equivalent to the SQL WHERE clause, and the string should follow the same syntax. InduSoft Web Studio Page 629 Tag Name Expression nRowCount DBCursorRowCount( nCursor ) Function Group Execution Windows Embedded Thin Client DBDelete Database/ERP Synchronous Supported Supported Supported