Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT CREATION OF TEMP.DBF'S
Message
From
02/10/1996 07:46:11
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00009011
Message ID:
00009100
Views:
30
>>cursors created by SELECT SQL are read-only - u can
>>make them r/w by USEing AGAIN (see tip in VFUG tips section)
>> if you need them shared over the network you should make sure the temp/work files are created in a network shared directory
>
>When you do the SELECT INTO TABLE (rather than INTO CURSOR) does that not create a read-write free table that can be shared like any other? This technique has worked OK for me. However, I do think that once you issue the SELECT and the table is created, if you want to share it, you need to close it, then reopen it in shared mode.

yes I used to use SELECT INTO TABLE but I prefer CURSORS as they
are deleted when closed - but yes this would work


Arnon
Previous
Reply
Map
View

Click here to load this message in the networking platform