Hi,

I've recently upgraded to the current (5.9.7) IBO release and was
surprised by a strange TIBOQuery behaviour, which forced me to downgrade
back to 5.9.3.
In the latest release, when you do something like:

query.SQL.Text := 'update T set F = :val';
query.ParamByName('val').AsFloat := 0.0;
query.ExecSQL;

the records get updated to NULL (!!!) instead of 0. Setting any non-zero
value works as expected (only 0 results in NULLs). Tested it also with a
freshly created table (to exclude any triggers / other dbms factors).
In 5.9.3 the same code works well, updates F to 0.
Delphi 10.2.3.

Could anyone please confirm experiencing similar behaviour? Or is it
just me? Can you do a quick check with a query like above and see what
happens?
I discovered it the hard way, i.e. scores of customers started calling
the help desk complaining about null check errors in the app (IBO tried
to store nulls instead of zeros in non-null columns).

regards
Tomasz

--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__