Subject Re[3]: [Firebird-Architect] ORs in Where statement
Author Helen Borrie
At 07:46 AM 13/06/2003 -0300, you wrote:
>Hello Doug,
>
>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.

So, Daniel, you are saying that calling a UDF as part of an evaluation
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