Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | calculated fields outcomes should be usable inside the same query | ||
---|---|---|---|
Product: | Base | Reporter: | fornarif <fornarif> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 2.0.3 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
fornarif
2006-07-24 16:41:26 UTC
Changed Issue type and summary hmm, I know I asked you to submit this issue, but I just found that it might be a duplicate of the already-existing issue 66837 - what'd you say? Hello, I think you'd be right, even if I can agree with the first description of the issue 66837 only, and less with all additional comments, pointing out fairly different problems, IMO. Best regards, Franco If I may put my $.02 in. I think the two issues are about the same thing. In a nut shell, the ability to create a column alias in a select statemnt and use that alias as a valid expression within another selectexpression in the same select statement. I would also argue that this is not an issue for OOo but rather for HSQLDB. It is true that HSQLDB does not allow this, nor does MySQL for that matter. As you point out MS Access does, and in fact I tested this - if you have a Base file that connects to an MDB file you can do this from within Base now. You can not do so within the designer, but turn the designer off and the parser will accept it and the results will be as expected. Sincerely Drew Jensen send further to the requirement team - if this issue get needless (some other enhancement cover it etc.), please close it thx Created attachment 73961 |