[RBASE-L] - Re: IN Query

[Doug Hamilton]

..in (&alldates)  or ...in  (.alldates)   or set var alldates = ('(' + .alldates + ')') Doug   jan johansen wrote: Ok,   I'm playing around (9.1.2.10317). I needed to change from an EQUAL to an IN. I have a TEXT column with comma seperated dates i.e. 2/21/2011,2/22/2011,2/23/2011.   SET VAR vmonthlydate DATE = 2/21/2011   EDIT ALL FROM schedule WHERE (CTXT(.vmonthlydate)) IN alldates gives the expected -ERROR- Parentheses required around the list of items for the IN clause. (2304)   However, EDIT ALL FROM schedule WHERE (CTXT(.vmonthlydate)) IN (alldates)  gives me <WARNING> No rows exist or satisfy the specified clause.  (2059)   What am I missing?   Jan