record selection order???

[APB1981]

Just curious about one thing.

Oracle 9.2/cr xi

If I set up the following in my record then it does not show NULL records:

({ORDER.STOCK} = 0 or isnull({ORDER.STOCK}))

But if I change the order then it does:

(isnull({ORDER.STOCK}) or {ORDER.STOCK} = 0)


Why is this???
Any help would be appreciated.

APB

APB

 

[IanWaterman]

Crystal does not like Nulls. You must always deal with them first. If you don't and crystal encounters a Null the whole formula fails to execute.

Ian

 

[APB1981]

Thanks Ian. I thought it would be something like that..

Appreciate your support.

APB.

APB