AnsweredAssumed Answered

Find Problem

Question asked by MichaelArnovitz on Jun 14, 2010
Latest reply on Jun 14, 2010 by 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**

Outcomes