Michael,
Try scripts0 SET duration_default = (quantnum/freqnumb) where rdate >= 9/1/2011 I believe you used the wrong divisor symbol. Jim From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Saturday, September 08, 2012 3:02 PM To: RBASE-L Mailing List 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
