Unidac 8.4.2 and 8.4.3 Access driver bug

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
VojkoCendak
Posts: 7
Joined: Thu 23 Apr 2020 12:52

Unidac 8.4.2 and 8.4.3 Access driver bug

Post by VojkoCendak » Fri 30 Apr 2021 18:52

Hi,
Sydney RAD studio Ent 10.4.2, Windows 10 pro 64bit
8.4.1 is working OK !
After ugrading to 8.4.2 and .3 the access TUniTable update is throwing:
exception number : 2
exception class : EUniError
exception message : [Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null).
Code:
ReceptMast.Edit;
ReceptMast['bEdt'] := True;
ReceptMast['iPotrjeno']:=0;
ReceptMast['sVodjaObrata']:=' ';
ReceptMast.Post;
ReceptMast.ApplyUpdates; == Error !

From dbMonitor:
UPDATE ReceptMast SET bEdt = ? WHERE sSifraRecepture = ?
bEdt IN Boolean True
Old_SifraRecepture IN WideString[14] '20003...'

Regards, Vojko

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Unidac 8.4.2 and 8.4.3 Access driver bug

Post by MaximG » Thu 13 May 2021 12:20

Sorry for not getting back to you sooner, we had long weekends. Could you please send us a sample project demonstrating the issue? For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

murkay
Posts: 14
Joined: Thu 08 Aug 2013 09:18

Re: Unidac 8.4.2 and 8.4.3 Access driver bug

Post by murkay » Tue 22 Jun 2021 17:00

Is this problem solved ?
In 8.42 and 8.43 there is a bug in Ms Access.
8.41 is Ok

VojkoCendak
Posts: 7
Joined: Thu 23 Apr 2020 12:52

Re: Unidac 8.4.2 and 8.4.3 Access driver bug

Post by VojkoCendak » Mon 19 Jul 2021 13:14

Hi,

I've send them example with database. Hope they'll check it.
Basically when you edit yes/no field in access table (change value) it reports:
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null).

goldesel
Posts: 2
Joined: Wed 19 Jul 2017 10:44

Re: Unidac 8.4.2 and 8.4.3 Access driver bug

Post by goldesel » Wed 01 Sep 2021 16:54

This error is still present in 8.4.4. When is this going to get fixed?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Unidac 8.4.2 and 8.4.3 Access driver bug

Post by MaximG » Wed 08 Sep 2021 08:34

We've reproduced the issue and fixed it. The required changes are included in the new UniDAC build, which we plan to release next week.

Post Reply