>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