Flush fox pro tables

[PeterOcean]

I have a problem where I am querying a fox pro table and I get back an empty recordset, when in fact the information is actually in the tables (I tried the same query in FP and I got the information back).

If I re query the table through VB a number of times eventually it will work. Obviously I don't want to write a loop that says only quit when we get back a recordset, but it's as if that is what I have to do.

Someone has mentioned that I should flush the tables before I do the query, once this is done everything should work the first time. Does anyone know how to do that, or is there any other options available.

Thanks for your help in advance

Peter

 

[jebenson]

PLease post code showing how you build your connection and/or recordset and how you are querying the tables.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson