General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>You do not understand me and I really need to run now, but anyway.
>
>Your expression is:
>
>myCol in ('Val1', 'Val2') or (myCol='Val2' and someLogicalCol)
>
>--------------------------
>
>That expression is contradictory as the first one is less restrictive than the second. If myCol = 'Val2' it's true and so there is no point to check the logical value.
>
>I assumed you wanted either val1 or (val2 only when some logical condition is true).
>
>Or may be you want: myCol is one of the values (1 or 2) or it doesn't matter what myCol is but if someLogicalCol is true, give me these records.
>
>So, please explain your conditions in English and remove ambiguity.
>
>
You're right. I didn't understand your point. I'll need to get back to the project manager on why it was speced out this way and get a better spec.
Unfortunately, this doesn't address the original question of why it worked in one environment and not another.
I don't think that piece of it is worth bothering with any more. It's working now so on to the next phase.
Thanks again.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only