Frank Schönheit - Sun Microsystems Germany ha scritto:
Hi Franco,
trying to build a little application with Base, I have found 2 bugs and
filed as many issues. In fact, I have more troubles with queries
(standard and qiq), but I cannot rule out that some of this troubles are
related to those ones I already filed. Do you mean it's better to wait
and see, or do you prefer I report each problem found? In case, I can
send a sample for each one.
In general, I think IZ is the best way to go - the issue won't get lost
them, even if it's marked as duplicate 'cause we find that it has the
same internal reason as another one. So, if you don't mid, I'd like to
ask you to just file them.
Ok! No problem.
And finally a question about a new feature. At present, it's not allowed
to use in any way, the result of a calculated field inside the same
query.
Can you elaborate on this?
Hi, Frank
Yes. Let's imagine a very common situation: we need to calculate a
markup based on some percentage. At the beginning, we have two fields:
the net price and the percentage rate. With them we can create a first
calculated field inserting this simple formula:
"net price" * "rate" / 100 AS "markup"
Now, if we need also the SUM of "net price" and "markup" (very common in
real life), we'll create a second calculated field, where we must
"repeat" the formula above and sum it to the net price, as follows:
"net price" + ("net price" * "rate" /100) AS "total"
Right? Well, in case of very simple calculated fields this couldn't be a
big problem, but when the formula is more complicated, isn't a safe
solution to repeat it in different places inside the same application.
Do you agree? It would be safer if we could use, for the second
calculated filed, this formula:
"net price" + "markup" AS "total"
This way, we'd have only one instance for each formula in our whole
application.
Ciao,
Franco
Ciao
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
