Tim

When you recover from an excess of good cheer, out of interest does ElevateDB carry out complete boolean evaluation or not?

eg in this

SELECT
_ID
FROM Companies
WHERE
_Name LIKE SUBSTR(:Value,1,3)+'%'
AND
StrippedCompanyName(_Name) = StrippedCompanyName(:Value)

if the first part is false will the second still be evaluated?


Roy Lambert

Roy,

<< When you recover from an excess of good cheer, out of interest does
ElevateDB carry out complete boolean
evaluation or not? >>

No, it always uses short-circuit evaluation for AND.  There's no point in
doing so.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< When you recover from an excess of good cheer, out of interest does
>ElevateDB carry out complete boolean
>evaluation or not? >>
>
>No, it always uses short-circuit evaluation for AND. There's no point in
>doing so.

I agree, but I just got to wondering with the 1011 error where I'd put a length test in so I suppose the error was raised before the tests were carried out. Seems fair enough and I now know.

Roy Lambert