Here's my situation, people:

I'm connection to DB/400 on an AS/400 using views and ODBC. When I connect the first time using my application I receive about 25% of the records I'm suppose to. The second and third time I run the application gives me the full result of the records I'm suppose to receive and every time after that is fine.

I know it's something to do with the connection settings but I'm just not sure what I'm suppose to tweak! How can I make VFP wait until all the records are brought over from the DB/400 Server?

The record set is fairly small in size (300 recs out of 1 million recs)