Element Details: SQL+Parameters
 Back


Available in: Logi Info Source code name: SqlParameters

SqlParameters specify the parameters for a SQL command.

Parameters are listed in the SQL command with question marks. For example, this command requires two parameters:

SELECT * FROM Customers WHERE State=? AND City=?

Parameter should be specified with SqlParameter elements. These should be listed in order.

SqlParameters do not work with ODBC connections.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
NullValue
UserDefined
When a parameter value matches the value of this attribute, NULL is passed into the database. The default NullValue is an empty string.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.ActiveSQL
DataLayer.SQL
HierarchicalLookup.SQL Lookup.SQL Procedure.SQL


CHILD ELEMENTS

Click element to drill down for more information.

SQL Parameter


 Back to top


 Chart Debug