Subject | Re[3]: [Firebird-Architect] ORs in Where statement |
---|---|
Author | Helen Borrie |
Post date | 2003-06-13T11:02:11Z |
At 07:46 AM 13/06/2003 -0300, you wrote:
sequence could change the state of the database and therefore alter the
result of the OR test? I don't see it. Please give an example of how this
could happen.
Helen
>Hello Doug,So, Daniel, you are saying that calling a UDF as part of an evaluation
>
>Thursday, June 12, 2003, 10:36:23 PM, you wrote:
>
>DC> At 6/12/2003 08:08 PM (Thursday), Daniel Rail wrote:
> >>- Complete evaluation is sometimes convenient when one operand is a
> >> function with side effects that alter the execution of the program
>
>DC> This is poorly stated. By definition "side effects" do not alter the
>result
>DC> of the expression evaluation (what I think you refer to as "the execution
>DC> of the program") but they can nevertheless be important. If I wrote a UDF
>DC> which logs execution somewhere I think would want it called wherever I
>used it.
>
>It's not my thinking and wording. It's the definition that I found in
>Delphi's help, word for word. And, reading the statement properly, it
>does refer to a function, and in Firebird's case it would be a UDF, as
>in your statement. I haven't thought of that scenario.
sequence could change the state of the database and therefore alter the
result of the OR test? I don't see it. Please give an example of how this
could happen.
Helen