ODBC to FoxPro 6.0

[JimM]

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

[BrentHedden]

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:

[JimM]

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