Two cursors accessing one database

[Frank Schima]

Hi Bill,


On May 14, 2005, at 6:24 PM, Bill Mounce wrote:

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

The first cursor is ReadWrite and has locked all the records in the 
table. This is why the second attempt fails.


Best regards,
Frank Schima