I feel your pain! Too often it is the simple things.
From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Saturday, September 08, 2012 3:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What is wrong with this syntax? Arg.....the \ should be a / oops <blush> Mike From: Michael J. Sinclair <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, September 8, 2012 4:01 PM Subject: [RBASE-L] - What is wrong with this syntax? Hi All, I have a table called scripts0 with these columns... rdate_ date duration_default real quantnum real freqnumb real This command fails with this error message... -ERROR- Column or variable (quantnum\freqnumb) not found (2515) UPDATE scripts0 SET duration_default = (quantnum\freqnumb) where rdate_ >= 9/1/2011 Is there a way to update the value of a column from the R> based on 2 other columns? Mike
