Documentation
Logi Composer (Zoomdata)
Logi Info
Logi Report
Logi Predict
Logi Ad Hoc
Logi DataHub
Knowledge Base
Logi Composer (Zoomdata)
Logi Info
Logi Report
Helpful Tools
Logi Spark Cast
Logi Info Sample Center
Logi Info Upgrade Advisor
Logi Report API Doc
Support
Submit a Ticket Request
View Support Tickets
License Manager
Product Download
Getting Started
Logi Composer (Zoomdata)
Logi Info
Logi Report
Forums
Logi Composer (Zoomdata)
Logi Info
Logi Report
☰
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