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