General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with SELECT-SQL in VFP7
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only