Devart Forums

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

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

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

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).

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

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.