Error on import of exponential number

[Gene]

I am importing data via OBDC from an SQL server. I am getting errors in interpetation of numeric values when importing exponential numbers. It is interpeting as example 7.10000000000000E-15 as 7.1. It is essentailly ignoring the exponential notation. Any ideas how I can correct this problem??

[Kurt Knippel]

quote:

---

Originally posted by Gene:

I am importing data via OBDC from an SQL server. I am getting errors in interpetation of numeric values when importing exponential numbers. It is interpeting as example 7.10000000000000E-15 as 7.1. It is essentailly ignoring the exponential notation. Any ideas how I can correct this problem??

---

Well, the problem is that 7.10000000000000E-15 is not really a number, it is the representation of a number, the text representation in this case. When importing this into a numeric field, Filemaker will drop the non-numeric part "E-15" and then you are left with 7.1.

I am not sure if there is a way around this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=