Logi Composer
Documentation
Getting Started
Knowledge Base
Forums
Logi Report
Documentation
Getting Started
Knowledge Base
Forums
Logi Report API Doc
Logi Info
Documentation
Getting Started
Knowledge Base
Forums
Logi Info Sample Center
Logi Info Upgrade Advisor
Other Products
Izenda
Exago
Support
Submit a Ticket Request
View Support Tickets
License Manager
Product Download
Forums
Events
☰
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.
Name
Possible Values
Description
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
Your session will automatically end soon.
Continue the Session