Hi, OO Base community:
www.openoffice.org/issues/show_bug.cgi?id=74071
(the SQL code is provided in the issue 74071)
Table alias is not a cosmetic feature. It is mandatory to build complex
queries when the same source table is invoked multiple times. Without
table alias, complex queries cannot be built.
OO Base currently provides 2 types of stored queries.
* SQL View
created through CUI (Tools - SQL)
stored on the DB engine side
handled by DB engine
* GUI Query
created through GUI
stored on the client side
handled by Base GUI parser
GUI Query in 2.1.0 always fails when table alias is in query statement.
Example:
* Create a new database.
* Create 2 test tables, as shown in the end.
* Select GUI Query ("Queries" in the left pane)
* Select "Create Query in SQL Window"
Note: still inside Base GUI, not handled by DB engine
* type in the contrived query statement, as shown in the end.
* Press the design mode button (switch to GUI mode)
4 tables of alias names appear in relation window.
No tables of the original name
No key connection lines between any tables.
* Press the design mode button (switch to text mode)
Table aliases disappeared in the "From" clause.
Table aliases remain in other sections of the query statement.
* Press the design mode button (switch to GUI mode)
6 tables icons appear in relation window,
4 in alias names, 2 in the original names.
No key connection lines exist on the table icons of the original
names.
Key connection lines appear correctly for table icons of alias names.
* Further switching between the GUI and text modes reveals no more
changes.
* Save as "qq test" and close the GUI.
Should see a stored GUI Query "qq test".
* Double click "qq test" to execute.
* error message:
The data content could not be loaded.
Column not found: tm01."ID module" in ...
Can someone advise how to solve this problem?
Thanks.
Ray
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
