Data Access and SQL > SQL Tables > Parameters
 
Parameters
The SQL SELECT statement of an IliSQLTable object can contain references to parameters. See Parameters. Here is an example:
SELECT ID, NAME, ADDRESS
FROM EMP
WHERE NAME = :name_p
In this example name_p is the name of a parameter and as such it must be preceded by a colon “:” in the SQL statement.
In addition, the parameter must be declared in the IliSQLTable object. This can be done either interactively through the SQL Data Source inspector in Rogue Wave Views Studio or in C++ as follows:
IliSQLTable* sqlTbl;
...
sqlTbl->appendParameter(“name_p”, IliStringType);
A value should be assigned to this parameter before the IliTable::select member function is called. This code extract only shows how the parameter is defined in C++. For a complete description of the code required to generate this SQL statement, see Creating the Definition in C++.
IliValue v(“Smith”);
sqlTbl->setParameterValue(“name_p”, v);
sqlTbl->select();
The parameter can subsequently be assigned other values as required.

Version 5.7
Copyright © 2013, Rogue Wave Software, Inc. All Rights Reserved.