omron — DBCursorRowCount

Appendix: Built-in Scripting Language This is an optional parameter. Returned value Returns a numeric value that represents the cursor handle. In case of error, returns a negative number. Notes See also DBCursorClose . Examples As used in a Math worksheet: DBCursorPrevious Moves the cursor to the previous row of the result set and copies that row's values to the mapped tags. If there is no previous row — that is, If the current row is the first — then the function returns an error code and doesn't change the mapped tags. 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 DBCursorPrevious( 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 In case of error, returns a negative number. Otherwise, returns 0. Examples As used in a Math worksheet:

DBCursorRowCount Gets the total number of rows in a SQL result set. Page 628 InduSoft Web Studio Tag Name Expression nCursor DBCursorOpenSQL( "DB1", "SELECT Column1, Column2 FROM Table1 WHERE Column1 > 3 ORDER BY Column1, Column2 DESC", "Tag1, Tag2") Function Group Execution Windows Embedded Thin Client DBCursorPrevi ouDsatabase/ERP Synchronous Supported Supported Supported Tag Name Expression nErrorCode DBCursorPrevious( nCursor ) Function Group Execution Windows Embedded Thin Client DBCursorRowCo unDtatabase/ERP Synchronous Supported Supported Supported