we got an error because the content of a double Field is "NAN" in a ADT table.
ADS 22.214.171.124 is in use and the program accessing the tables is written in Delphi.
The Client uses dll's with the version 126.96.36.199.
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