NaN - not a Number
Posted: Thu 08 Mar 2012 08:32
Hello!
we've got the following problem:
We use an IBCQuery with ReadOnly=false (formaly RequestLive) to update a table-row in a Firebird Database (2.1 or 2.5). There is a column with type "double precesion" which contains a NaN-Value.
The update fails with an exception at the post-command because the update-statemant generated from IBCQuery is invalid in the Where-clause because of the NaN-Value.
We took a look at the sourcecode in unit MemData. The exception occurs in TMemData.CompareFieldValue when calling BitConverter.Int64BitsToDouble.
Is it possible to fix the problem at this position by checking the value for NaN (or Infinity) or can you tell us an other solution?
Thank you for your help.
Greetings
we've got the following problem:
We use an IBCQuery with ReadOnly=false (formaly RequestLive) to update a table-row in a Firebird Database (2.1 or 2.5). There is a column with type "double precesion" which contains a NaN-Value.
The update fails with an exception at the post-command because the update-statemant generated from IBCQuery is invalid in the Where-clause because of the NaN-Value.
We took a look at the sourcecode in unit MemData. The exception occurs in TMemData.CompareFieldValue when calling BitConverter.Int64BitsToDouble.
Is it possible to fix the problem at this position by checking the value for NaN (or Infinity) or can you tell us an other solution?
Thank you for your help.
Greetings