bw2:using_variables
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
bw2:using_variables [2023/12/19 08:51] wgates [Example 3] |
bw2:using_variables [2023/12/19 09:02] (current) wgates |
||
|---|---|---|---|
| Line 103: | Line 103: | ||
| The step named “SQL Command_getData” uses the SQL statement: | The step named “SQL Command_getData” uses the SQL statement: | ||
| - | <code sql>select | + | <code sql>SELECT |
| - | t0.CardCode, | + | CardName, |
| - | from OCRD t0 | + | CardType |
| + | FROM OCRD | ||
| </ | </ | ||
| This produces a list of records that feeds into the loop “Loop_ProcessRecords.” The step variable created for “CardCode” is: | This produces a list of records that feeds into the loop “Loop_ProcessRecords.” The step variable created for “CardCode” is: | ||
| - | < | + | < |
| This step variable is used in the FileWriter_VariableTest step. | This step variable is used in the FileWriter_VariableTest step. | ||
| Line 194: | Line 195: | ||
| * Only one of these can be selected at once, and they only apply in the step in which they are enabled. | * Only one of these can be selected at once, and they only apply in the step in which they are enabled. | ||
| * **JSON:** Selecting this will escape reserved characters for a JSON file. See the table below for more information. | * **JSON:** Selecting this will escape reserved characters for a JSON file. See the table below for more information. | ||
| - | * This will generally be used in a Databuilder step | ||
| * **XML:** Selecting this will escape any reserved characters for an XML file. See the table below for more information. | * **XML:** Selecting this will escape any reserved characters for an XML file. See the table below for more information. | ||
| - | * This will generally be used in a Databuilder step | ||
| * **SQL:** Selecting this will escape reserved characters for SQL Server see table below for more information | * **SQL:** Selecting this will escape reserved characters for SQL Server see table below for more information | ||
| * **Replace empty values with NULL:** This will take any empty strings or blanks ex '' | * **Replace empty values with NULL:** This will take any empty strings or blanks ex '' | ||
bw2/using_variables.1702993873.txt.gz · Last modified: 2023/12/19 08:51 by wgates
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
