>True, but it is still a surprise that can hurt you when you don't need the pain.
>All that the VFP7 Help says on the matter, at least in the logical place to read (i.e. the FROM clause) is: "
FROM ...Lists the tables containing the data that the query retrieves. If no table is open, Visual FoxPro displays the Open dialog box so you can specify the file location. Once open, the table remains open once the query is complete. ". This can easily be interpreted as 'if I already have the required table(s) open, then it will use them and leave them open when it is finished'. This is very different than 'regardless of the state of the tables involved I (SQL Select) will open them again for my exclusive use and them leave them open after I am finished'.
Yes, it was an unpleasant surprise for me, too.
>Are we sure that Select actually does make use of the opened tables on subsequent Selects?
I understand SELECT uses the equivalent of USE...AGAIN. Which works faster when the table is already open, than when it isn't. And no, I am not completely sure about the details.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
