2 Replies Latest reply on Jun 14, 2010 1:38 PM by MichaelArnovitz

    Find Problem

    MichaelArnovitz

      Title

      Find Problem

      Post

      I have an odd problem I haven't seen before and was hoping someone could help me out.

       

      I just created a new database. Big but fairly simple.

      About a dozen fields, with one auto-enter serial number field labeled "ID". 

      One table, no relationships. About 12.3 MM records.

       

      I need to peel off the first million records and export them as a CSV file.

      So I did a find in the ID field of ≤1000000. That should have given me a found set of the first million records.

       

      But it didn't. Instead I got 7 records: 1, 10, 100, 1000, 10000, 100000, 1000000.

      I see what's happening, but I don't understand why.

      Why am I getting powers of ten instead of the first million records?

       

      **Filemaker Pro 10; Mac OS X 10.6.3; iMac 27" Quad I7; 8 GB RAM**