Query Defs that support
UPDATE / INSERT / DELETE / SELECT INTO
with EscapeProcessing = TRUE
http://qa.openoffice.org/issues/show_bug.cgi?id=37688
OR
Ability to reference aliases within the select statement. i.e.
SELECT *, DATEDIFF( 'dd', DATE_COL, CURRENT_DATE) AS AGING
FROM T1
WHERE AGING >= 30 AND AGING <= 59
http://qa.openoffice.org/issues/show_bug.cgi?id=66837
http://qa.openoffice.org/issues/show_bug.cgi?id=86169
OR
UNION | INTERSECT | EXCEPT with EscapeProcessing = TRUE
AND
If a common named parameters is used in multiple select statements
therein, then prompt only once and use it in each.
http://qa.openoffice.org/issues/show_bug.cgi?id=51380
http://qa.openoffice.org/issues/show_bug.cgi?id=57513
OR
Ability to create
SELECT DISTINCT A.A1, AB.B1, BC.C1, C.C2 FROM A LEFT OUTER JOIN AB ON
A.A1 = AB.A1 LEFT OUTER JOIN BC ON AB.B1 = BC.B1 LEFT OUTER JOIN C ON
BC.C1 = C.C1
using the GUI designer
OK - there isn't one for this exactly...but this would do
http://qa.openoffice.org/issues/show_bug.cgi?id=64649
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
