General information
Category:
Coding, syntax & commands
You can save yourself 2 steps in your code by issuing the command:
USE IN table1
This replaces:
SELECT table1
USE && release table
SELECT myCursor
This will
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only