Differences

This shows you the differences between two versions of the page.

--- bw:sql_command_tool [2022/08/02 10:28]
akoehler
+++ bw:sql_command_tool [2022/08/02 10:35] (current)
akoehler [SQL System Variables]
@@ Line 139: / Line 139: @@
 ====== SQL System Variables ======
+^ Name           ^ Description         ^
+| CommandType       | The command type chosen in the SQL tool ex. Reader, Non-Query      |
+| DataSourceFields |The fields pulled from the data source will only show up when executing the query in the SQL tool and not during a test run|
+| DataSourceResultsTable         | The results from executing the query in the workflow. Will only show up when executing the query in the SQL tool and not during the test run      |
+| QueryString         | The current query that is being executed     |
+| SQLCommand        | Used for an older version of Bizweaver no longer returns a value    |
+| SQLResultsCount         | The total amount of records that were retrieved during a query       |
+|StepMessage       | During a failure the reason for failure will be populated here     |
+| StepStatus        | True or False     |
 ======SQL Tips======

Wiki