hello,

I am working with cursors that are created by foxpro cursor adaptor object. When I try to select some records from these cursor, I realized that sql sentences are executed in database not in cursors. For this reason, I am getting the records from database not from my cursors. For example I have one cursor cuser when I write

select * from cuser into cursor result

when I look the cursor result, I see the records of the table "user" of the database not the record in my cursor cuser.

Is there any way to execute my sql sentences on cursors not on database when working with cursor adaptor objects?