Very Computer

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???

Thanks

Are you also doing a corresponding 'Set myvar = Nothing'? If you can
provide a little more info, perhaps I can try to help. I'd like to also
know why are you opening a recordset against the same variable in a loop
(if that's the case)?

John Conley

Quote:> 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.