Drew Jensen wrote:
Ocke Janssen wrote:
PS: May be we should not offer fusion, collect and intersection in
the UI.
then again adding three new aggregate functions is not that big a time
hit really (you would know better then anyone what that hit would be)
- and - what is the point of working on a FOSS package if you don't
get to scratch your own itch every now and then. I sincerely mean that.
- but...if you are really looking for some enhancements for the
parser, LOL, I'll be bold and propose that any of the following would
have a much higher ROI for your time in regards to the number of users
that would find it useful, IMO:
Query Defs that support
UPDATE / INSERT / DELETE / SELECT INTO
with EscapeProcessing = TRUE
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
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.
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
Just some thoughts.
Take them for what ever they are worth.
I currently don't have the issues at hand, may be you could help me ;-)
Best regards,
Ocke
Respectfully,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
