Host Parameter (SQL)

Introduction

The SQL Host Parameter defines placeholder in an SQL command where the value is provided at execution.

Syntax

primary-host-parameter ::=
  ':' regular-identifier

Remarks

The software executing the command should provide the parameter values.

Software using the Fernhill SCADA ODBC Driver calls the SQLBindParameter() function to bind the parameter value. Binding associates the parameter in the SQL command to data provided by the program. See Using ODBC From C/C++ for an example of binding parameters using SQLBindParameter().

Software using the Fernhill SCADA .NET Framework Data Provider would add parameters to the parameter collection of the SQL command. See Using VB.NET and the .NET Framework Data Provider to Access Fernhill SCADA for an ADO.NET example.

Further Information

Value Expressions (SQL)

To learn more about SQL scalar value expressions.

Fernhill SCADA Structured Query Language (SQL)

To learn more about the SQL features in Fernhill SCADA.

Glossary

For the meaning of terms used in Fernhill SCADA.