Data Transformation Engine ODBC Adapter Reference Guide

Chapter 6 - Binding Values in DBLOOKUP/DBQUERY Specifying the Data Type
ODBC Adapter Reference Guide
25
The following table lists the data type indicators and the relationship between each
data type indicator and the ODBC data types.
Data Type Indicator ODBC data type
T or TEXT SQL_CHAR
N or NUM or NUMBER SQL_NUMERIC
D or DATE SQL_DATETIME
Note For information about item formats and interpretation, refer to Item Type
Properties.
As an example of specifying a data type, to bind a date value to a statement, you
must specify that the value be of data type DATETIME. The SQL statement would
be entered as:
DBLOOKUP("select Age from Person where DateOfBirth=:bind([DATE]," +
DateItem:Row + ")",
"DB.mdq",
"MyDB")
If the
[DATE] data type indicator is not specified, the trace file from the database
adapter displays the following error message:
Message: [Microsoft][ODBC Microsoft Access 97 Driver]
Data type mismatch in criteria expression.