I have the weirdest thing, I loop through a series of items and for each I
do a select statement using SET myvar =
DBobject.OpenRecordSet("select...", dbOpenSnapshot). Every time I run this
procedure, the results should be the same but the problem is that sometimes
records are returned and sometimes nothing is returned. So when nothing
was returned I went in the debug window and executed the same query, no
matter what I selected from this table I got no records so I closed the
record set and then I got some records. But this is never consistent.
The database is foxpro 2.6, I query records from one table only, I close
the recordset after I used it.
I don't get it because in this loop I also do the same query (using the
same Where clause) on another table and it always returns the same values.
I don't get this, I have spent alot of time trying to figure out what was
wrong, sometime the query works other times it doesn't WHY???