Two cursors accessing one database

[Bill Mounce]

I have frequently had this problem and it is time now to figure out why.

I have one cursor that has loaded all the records from the database: 
"select * from TABLE"

Then I create a second cursor and issue the same command, and the 
cursor responds with a nil.


   tCursor = mDataBase.SQLselect( "select * from TABLE", kV_Server, 
kV_ReadWrite, kV_Random )
   if(tCursor <> nil) then
     r = tCursor.FirstRecord
   else
     msgbox "There are no records in this database."
   end if


Generally, the first cursor is a property and the second is dimensioned 
in the method (if that matters).

Any suggestions? Thanks.

BIll