Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding Cursors - Followup
Message
From
08/10/1999 11:42:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00274264
Message ID:
00274289
Views:
27
>With the help of my father who has been doing FoxPro 2.6 development for 15 years I think I have found the answer to my cursor problem.
>
>I use SELECT statements to retrieve all my data from tables. I was under the assumption that once the SELECT command obtained the information from the FROM tables that it closed those tables. This does not seem to be the case. After a SELECT statement the tables are left open in their own workspace.
>
>It works like this:
>
>SELECT * FROM table1 INTO CURSOR myCursor
>SELECT table1
>USE && release table
>SELECT myCursor
>[PERFORM OPERATION]
>USE && release cursor
>
>I hope that I have helped prevent some long nights that I had to suffer through to find out what was going on.
>
>Cheers!
>Tadd Bryan.


Tadd,
This isn't a question I think. If a confirmation, yes tables not closed automatically but opened automatically (if not already opened somewhere) with an SQL.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform