Jan, That's not a place for IN, that's a place for CONTAINS.
EDIT ALL FROM Schedule WHERE alldates CONTAINS (ctxt(.vmonthlydate)) However, your list of dates isn't in the best form for this, since CTXT(.vmonthlydate) will give you "02/21/2011" with a zero-two for the month, and it won't be found in your list that left those zeros out. Bill On Mon, Apr 4, 2011 at 12:24 PM, jan johansen <[email protected]>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 >
