Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: MSSQL2000: Invalid Precision Value
MSSQL2000: Invalid Precision Value
Posted: 2007/06/14 03:24
 
Hi Dmitry.

I get this error when trying to update a table containing a float field.

It's due to the fact that MSSQL2000 give a 'precision' of 53 (not editable) for the 'float' field type, and I suppose that when you set the parameters' type and size you use the values you get from the server.

Is there a way to avoid this problem ?

Thnx.

BTW: Your did a really good job with the anyDAC libraries.

P.S. The 'Search Forums' is case sensitive... nearly impossible to find relevant old posts.
Re:MSSQL2000: Invalid Precision Value
Posted: 2007/06/22 02:42
 
Hi

I cannot reproduce this issue. Could you provide me:
- your MSSQL ODBC driver version;
- your AnyDAC version;
- your table CREATE statement.

Or just provide me small demo application.

Regards,
Dmitry