ODBCBindCol
Binds a column to a tag.
| Function | Group | Execution | Windows | Embedded | Thin Client | Mobile Access |
|---|---|---|---|---|---|---|
| ODBCBindCol | ODBC | Synchronous | Supported | Not supported | Executed on Server | Not supported |
Syntax
ODBCBindCol( numHandler, strColName, strColType, strTagName )
- numHandler
- The handler returned by the ODBCOpen function.
- strColName
- The Database column name.
- strColType
- The SQL data type (one of the following):
- SQL_BIT
- SQL_TINYINT
- SQL_LONGVARCHAR
- SQL_CHAR
- SQL_VARCHAR
- SQL_DECIMAL
- SQL_NUMERIC
- SQL_DATE
- SQL_TIME
- SQL_TIMESTAMP
- SQL_DOUBLE
- SQL_REAL
- SQL_SMALLINT
- SQL_INTEGER
- strTagName
- The name of the tag to bind to the column.
Returned value
| 0 | Success |
| 1 | Invalid Handler |
| 2 | Invalid parameter type |
| 3 | One of the parameters has an empty string |
| 4 | ColType contains an invalid type |
Notes
Every time you finish binding columns, you must call the ODBCQuery function.
Examples
| Tag Name | Expression |
|---|---|
| Tag | ODBCBindCol( 5, “OrderDate”, “SQL_DATE”, “Order_Date” ) |
See also: ODBCUnbindCol()