Sorry, I just meant to expand on your answer, as this is a question that occurs regularly here. It wasn't pointed directly at you :-)

Barbara

>Thanks Barbara,
>
>I was just giving Ed an example of when a filtered table is created instead of
>an actual file presence.
>
>-myron-
>=========================================
>>Myron, if you want to force VFP to create a cursor instead of a filtered version of the base table, just add an extra field
>>

>>SELECT *, .T. as NewField from Mytable into Mycursor
>>

>>If you need a read-write version of a cursor, then USE it again. The new copy will be read-write.
>>

>>use dbf('MyCursor') again in 0 alias NewCursor
>>

>>
>>HTH
>>
>>
>>>On a plain Select-SQL VFP does not alway create a new table, it sometimes (based on
>>>how you structured your SQL) just does a filter over the source table.
>>>
>>>To test this do:
>>> SELECT * FROM -tablename- INTO CURSOR fTest
>>> SELECT fTest
>>> ? DBF()
>>>
>>>-myron kirby-
>>>===================================
>>>>Hi Ed,
>>>>
>>>>I wandering why any cursor created by plain Select-SQL is not editable. What is behind the scene that prevents editing?
>>>>
>>>>Sincerely, Igor Gelin, System Developer.
>>>>