Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

MSSQL Invalid precision value

 Post Reply Post Reply
Author
VRACHIOLIS NIKOLAOS View Drop Down
New Member
New Member
Avatar

Joined: 15 Dec 2018
Posts: 23
Post Options Post Options   Quote VRACHIOLIS NIKOLAOS Quote  Post ReplyReply Direct Link To This Post Topic: MSSQL Invalid precision value
    Posted: 12 Sep 2019 at 10:41am
Hi,

I face an EAureliusOdbcException with message 'Error -1: [Microsoft][ODBC Driver 11 for SQL Server]Invalid precision value' on a field that is declared as Nullable<Double> on the model and as float at SQL Server (version 2014).

I also tried as Decimal(5,2) but the same happens.

I face the error on every number I insert, even 0.

What I miss here?
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2389
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2019 at 4:25pm
Hi,
I cannot reproduce the problem here. Can you maybe try with a different MSSQL driver and/or different SQL Server version to see if it makes a difference?
Back to Top
VRACHIOLIS NIKOLAOS View Drop Down
New Member
New Member
Avatar

Joined: 15 Dec 2018
Posts: 23
Post Options Post Options   Quote VRACHIOLIS NIKOLAOS Quote  Post ReplyReply Direct Link To This Post Posted: 14 Sep 2019 at 12:29pm
How to use different SQL driver? Do you mean use FireDac instead of Native driver?
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2389
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 15 Sep 2019 at 2:49pm
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down