Get Row Count
Gets a count of rows.
Inputs
| 1. | Data Source Name | (Mandatory) | The name of a system DSN configured on the machine where scripter server is hosted. |
| 2. | Data Source User | (Optional) | The user name for the DSN |
| 3. | Data Source Password | (Optional) | The password for the DSN |
| 4. | Database Schema Name | (Optional) | The schema name within the database |
| 5. | Database Table Name | (Mandatory) | The Table name within the database |
| 6. | Predicate String | (Mandatory) | The WHERE clause predicates for the select statement. |
Fig. 1 - Get Row Count - Inputs
Outputs
| 1. | Row Count | The number of rows returned by the query. |
Fig. 2 - Get Row Count - Outputs
Outcomes
Depending on the success of the operation:
| 2. | Fail |
| 1. | Success |