>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
- 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.