When I attempt to read a FoxPro free table from FileMaker 8 with ODBC my where clause will find the record I'm looking for only if it is within the first 2130 records of the FoxPro table. Is this possibly a known problem with FileMaker? I'm thinking it is probably a corrupt index in FoxPro because if I remove the where clause altogether it gets all the records. Any advice?

Thanks,

Jim

I'm not super knowledgable with ODBC, but I'll attempt.

Is there some kind of ODBC restriction with FoxPro? I know certain databases have to have the data formatted in a specific way (other than what FileMaker does). I know this is especially true with dates.

Do you have another DB program that you can test this same where clause on? You can get MySQL for free. I suppose you could rule out whether it's FileMaker or FoxPro this way.

Hopefully this helps :smile2:

Thanks for the suggestions Brent. I ended up changing the Collating sequence to General vs. Machine in the ODBC DSN setup. Seems to have done the trick.

Jim