>I tried the following code:
>Select * from MyDbf into Cursor MyCur
>Select * from MyCur ---> Give an error
>
>Select * from MyDbf into Cursor MyCur where .t.
>Select * from MyCur ---> works fine
>
>Am I missing something here...how can I get consistent results ??
>
>Regards,
>Gerard

Sometimes Visual FoxPro decides to use a filter on an existing table, instead of creating the cursor as a separate table. In this case, the cursor can't be used in subsequent SELECT statements.

To avoid this, use the NOFILTER clause:

select * from MyDbf;
  into cursor MyCur;
  nofilter
select * from MyCur

This requires VFP 6 or later (or was it 5? - not sure); in earlier versions, a workaround is to add an additional field, which is not part of the table:

select *, .T. as UnusedField;
  from MyDbf;
  into cursor MyCur
select * from MyCur