Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What happens with SELECT
Message
 
 
To
20/07/2006 12:00:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01138114
Message ID:
01138119
Views:
11
select * from somefile into cursor crsTemp NOFILTER
USE IN somefile 
>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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform