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()

ODBCBindCol