Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE ... IN 0 vs. SELECT()
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00612484
Message ID:
00612516
Views:
23
>Greetings Foxperts,
>In VFP7, is there any inherent advantage in using 0 or SELECT() when USEing a table? i.e.: USE gooddata IN 0 ALIAS... or USE gooddata IN SELECT() ALIAS...
>Just wondering.... Thanx

SELECT() will return the currently selected table area. And hence if there is already a table open in that area, it will be closed and the new one put in its place.

USE IN 0 will tell it to go into teh next available spot, not closing other open tables.

I believe that USE IN does not select the table afterwards, and you may be best doing
SELECT 0
USE gooddata ALIAS ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform