From: craig.futterman@nospam.comcast.net   
      
   Thanks Liz,   
   Another fun Saturday night....   
   Craig   
   "Liz McGuire"  wrote in message   
   news:45c5536e@pnews.thedbcommunity.com...   
   > Craig,   
   >   
   > stMR = "\\" + stMR   
   >   
   > ...should do it.  The ObjectPAL help on setGenFilter explains that when   
   > your filter criteria starts with a number, you need to put the \\ before   
   it.   
   >   
   > Liz   
   >   
   >   
   > Craig wrote:   
   > > I have a field called hospitalnumber and I want to use setGenFilter.   
   > > The field looks like this 123-45-67 (with the dashes)   
   > > When I use code:   
   > >   
   > >   AR["HospitalNumber"] =stMR ;// stMR is the hospitalnumber   
   > >    TCBio.setGenFilter(AR)   
   > >   
   > > I get the error: "The filter expression in field HospitalNumber is not   
   valid   
   > >                        "Operation not applicable"   
   > > Is this because of the dashes?   
   > >   
   > > I tried to break it apart and make it look like: 123/-45/-67. But that   
   > > didn't seem to work.   
   > > Any work arounds?   
   > > Thanks   
   > > Craig   
   > > Craig Futterman   
   > >   
   > >   
   > >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)