Passing a parameter to the SQL command
Jhon wrote in with this question recently:
"How can I pass the parameter to the SQL command if they are stored in a Source file?"
-- Deb Tart, associate editor
Software/Hardware used:
Software/Hardware used:
ASKED:
February 22, 2006 4:14 PM
UPDATED:
February 22, 2006 10:45 PM
Answer Wiki:
Put a colon in front of the variable. Example:
localVariable = 7;
EXEC SQL SELECT field FROM file WHERE key=:localVariable;
Example 2:
DlocalVariable B
C/EXEC-SQL
C+ SELECT field FROM file WHERE key=:localVariable
C/END-SELECT
--
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
