Skip to Content
-1
Former Member
Oct 14, 2016 at 12:37 PM

"NAN"-value in a double field of a ADT Table

1048 Views Last edit Nov 15, 2016 at 02:40 PM 2 rev

Hi Everybody,

we got an error because the content of a double Field is "NAN" in a ADT table.
ADS 11.10.0.22 is in use and the program accessing the tables is written in Delphi.
The Client uses dll's with the version 8.10.0.38.

According to - http://devzone.advantagedatabase.com/dz/content.aspx?key=48&id=72386
-> ... For ADT table we do ensure that only valid data are stored in the numeric field. ...
-> ... Normally, the higher level ADS client (For example, ADS TDataset client for Delphi), will ensure that the API is called only with valid data so there should not be any wired data in the table. ...

Questions I am not able to answer on my own:

1. How is it possible to get a "NAN" value in a double field?
2. What can we do to ensure this is not happening anymore?
3. How can I find such broken fields before an Error occurs? -> Scanning all fields of all records in a loop is not really a option, because we need to check about 70.000 ADT tables with all together about 750GB

Any ideas, questions, suggestions, ... are welcome!
Thanks to everyone who is willing to help! - Marcel