General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hilmar,
OFF TOPIC...
Yesterday in a newspaper here there was a picture of a woman standing in the walkway of a home and there was snow about 2.5-3 ft high on either side of the walkway.
The caption said that a freak hail storm had caused major trouble in LaPaz.
Would that all have been hail from the storm, or do you have snow there at this time of year?
Just curious.
>>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.
Previous
Next
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