CREATE VIEW "TEST" AS
SELECT
*
FROM
Contacts  
JOIN Career ON Career._fkContacts = Contacts._ID
JOIN Companies ON Companies._ID = Career._fkCompanies

---

 Comments

---

This had to do with the way that the SQL is extracted from the editor and assigned to the TEDBQuery.SQL property. When the text is assigned directly to the TStrings (SQL property), there isn't an opportunity to intercept the assignment and make sure that things actually changed. This has now been corrected so that the outer query will not be re-prepared every time, thus incurring the opening time of the underlying view.

---

 Resolution

---

Fixed Problem on 7/8/2011 in version 2.05 build 11

---

 Products Affected

---

ElevateDB Additional Software and Utilities