Thierry,

VFP doesn't always return a "real" cursor. When you run a SQL SELECT against a single table and you don't have any calculated fields, VFP sometimes applies a FILTER on your base table. You can prevent this by adding the NOFILTER clause to your SQL SELECT. You can check if this is the case with DBF("test"). Most probably, this returns "MyTable.dbf".

I don't know why you see a different behaviour in VFP6 and VFP7, but this behaviour certainly existed in earlier versions, too.

HTH
>Hi all,
>
>I have some trouble when using a signle SELECT-SQL command in VFP7. These trouble didn't exist in VFP6. Any explication will be welcome
>
>SELECT * FROM mytable.dbf INTO CURSOR test
>
>When I watch the DataSession I have 2 Aliases "test" and "mytable" I close the "mytable" Alias.
>
>In VFP6, mytable.dbf was closed and doesn't appear anymore in the Alises list, so, and I can type the command "USE mytable.dbf" and all is allright
>
>In VFP7, mytable doesn't appear in the Aliases list, but when I type "USE mytable.dbf" VFP tell me that the file Mytable.dbf is in use.
>
>I try the same with " SELECT * FROM mytable.dbf INTO CURSOR test READWRITE " and I was surprised to be able to type "USE mytable.dbf" in VFP7 after closing the Alias "mytable"
>
>thanks for any answer
>Thierry