Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem opening views
Message
 
 
To
17/03/2007 12:57:18
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01204975
Message ID:
01205054
Views:
21
>This is what I think happens...
>Views/cursors are effectively dbf files with a .tmp extension, but the first part of the tmp file is created when the view requested, so when the second opening occurs, the .tmp filename is different from the first, hence we don't get the "File is in use" message.

Hi Alan,

A view is just a cursor created with SELECT-SQL. VFP may as well check in advance to see if an alias already exists and assign default one, if it does.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform