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

In your CA SelectCmd property put NOFILTER clause. That will create a real cursor not just filtered Table.