>>>Hi all, i'm implementing a dinamyc filter but i'm getting error in next case:
>>>set filter to LINE_STATUS = 'INV' or LINE_STATUS = 'NQH' and (alltrim(UPPER(HOSPITAL)) == 'JFK')
>>>I need to add quotes FOR -> (LINE_STATUS='INV' OR LINE_STATUS='NQH') to let filter works in this case. Some ideas?
>>>T.I.A.
>>
>>lcFiltStat = "LINE_STATUS='INV' OR LINE_STATUS='NQH' and (alltrim(UPPER(HOSPITAL)) == 'JFK'"
>>
>>or
>>
>>lcFiltStat = [LINE_STATUS='INV' OR LINE_STATUS='NQH' and (alltrim(UPPER(HOSPITAL)) == 'JFK']
>>
>>Set filter to (lcFiltStat)
>>
>>or
>>
>>Set filter to &lcFiltStat
>>
>>I THINK!!!
>>
>>HTH
>
>Set filter to (somestring) will not work.
Yes, I thought so but couldn't be arsed checking in my systems to find one. That's why I cited also:
Set filter to &lcFiltStat
I didn't just put that cos I'm sick of being jumped on by a UT member for using macro subs instead of named expressions. And waht happens instead? - I get jumped on for using a named expression. You just can't win! :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.