ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invalid Precision: cbColDef value out of range (https://www.excelbanter.com/excel-programming/406000-invalid-precision-cbcoldef-value-out-range.html)

Otter

Invalid Precision: cbColDef value out of range
 
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

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




Otter

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






All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com