Differences

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

--- bw2:sql_command_tool [2022/08/02 10:36]
akoehler
+++ bw2:sql_command_tool [2023/12/29 14:09] (current)
wgates [Reader (SQL Server and HANA)]
@@ Line 59: / Line 59: @@
     - When variables are used, they are subject to standard syntax rules regarding text vs. numeric values. This means that text variables MUST be enclosed in single quotes.
-The following image shows the same SELECT statement as illustrated above but with a variable in the WHERE clause.
+The following shows the same SELECT statement as illustrated above but with a variable in the WHERE clause.
-{{  :bw:sqlimage2.png?411x72  }}
+<code sql>
+SELECT
+	CardCode,
+	CardName
+FROM ocrd
+WHERE CardCode = 'WorkFlow(Variables).Get(CardType)'
+</code>

Wiki