Gordon Hughes
asked on
SQL Code error
Hi
Can anyone tell me what is wrong with this formula
{WOEQLIST.LOCATION} = {?Pm-?Factory} and
({WOEQLIST.UD3} = "Yes" or
({WO.WOTYPE} = 'WRF' and {WOEQLIST.UD3} is not 'Resolved')
It keeps syaing the ) is missing before the is not
Gordon
Can anyone tell me what is wrong with this formula
{WOEQLIST.LOCATION} = {?Pm-?Factory} and
({WOEQLIST.UD3} = "Yes" or
({WO.WOTYPE} = 'WRF' and {WOEQLIST.UD3} is not 'Resolved')
It keeps syaing the ) is missing before the is not
Gordon
ASKER
Hi
Thanks for your speedy response
It still says missing ) before the is not
Gordon
Thanks for your speedy response
It still says missing ) before the is not
Gordon
There is no IS in Crystal except for use with arrays
Try it this way
{WOEQLIST.LOCATION} = {?Pm-?Factory} and
({WOEQLIST.UD3} = "Yes" or
({WO.WOTYPE} = 'WRF' and {WOEQLIST.UD3} <> 'Resolved') )
What values are in WOEQLIST.UD3?
mlmcc
Try it this way
{WOEQLIST.LOCATION} = {?Pm-?Factory} and
({WOEQLIST.UD3} = "Yes" or
({WO.WOTYPE} = 'WRF' and {WOEQLIST.UD3} <> 'Resolved') )
What values are in WOEQLIST.UD3?
mlmcc
ASKER
Hi mimcc
I recognised it should be <> but is still does not work
The WOEQLIST.UD3 could have a value or be blank, which I think contibutes to the issue
I have got around the issue by puuting a value in the field, but am concerned the users may forget
Gordon
I recognised it should be <> but is still does not work
The WOEQLIST.UD3 could have a value or be blank, which I think contibutes to the issue
I have got around the issue by puuting a value in the field, but am concerned the users may forget
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This mmic is good
{WOEQLIST.LOCATION} = {?Pm-?Factory} and
({WOEQLIST.UD3} = "Yes") or
({WO.WOTYPE} = 'WRF' and {WOEQLIST.UD3} is not 'Resolved')