Invalid Precision: cbColDef value out of range

[Otter]

I get the following message when I try to use a parameter query with a
numeric field to Teradata. I can use a character field just fine.

[NCR][ODBC Teradata Driver] Invalid precision: cbColDef value out of range

 

[Bernie Deitrick]

Otter,

Try wrapping your variable or number in a CStr( ) to force it to be a
string for the query.

HTH,
Bernie
MS Excel MVP

 

[Otter]

How do I do that with Microsoft Query within EXCEL?

Otter,

Try wrapping your variable or number in a CStr( ) to force it to be a
string for the query.

HTH,
Bernie
MS Excel MVP

I get the following message when I try to use a parameter query with a
numeric field to Teradata. I can use a character field just fine.

[NCR][ODBC Teradata Driver] Invalid precision: cbColDef value out of range