I have a database which I use to track IP addresses, and one of the fields it maintains is an aggregate IP address which is represented by a scalar integer value from 0-(2^32-1).
When I export this data, FileMaker considerately exports this value in scientific notation and maintains about five digits of precision.
How do I get FileMaker to export the original value?
If I treat the field as a string, it won't sort properly - which is the whole reason for the field in the first place (since IP addresses as strings don't sort properly).
-- Thanks, Verne