Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What happens with SELECT
Message
From
20/07/2006 12:00:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
What happens with SELECT
Miscellaneous
Thread ID:
01138114
Message ID:
01138114
Views:
61
I am trying to gain a better understanding of what happens with SELECT INTO CURSOR. If I issue a command such as
select * from somefile into cursor crsTemp
It appears that the original file (somefile) is opened by the OS although it is not technically USED. Is this correct? If yes, then what do we have to do to close the file so that it is available to other programs or so that it can be overwritten? I have tried to
use in crsTemp
copy to somefile
but I still get an error that says the file is open. Can someone shed some light on this?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform