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

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" wrote in message
...
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

How do I do that with Microsoft Query within EXCEL?

"Bernie Deitrick" wrote:

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" wrote in message
...
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