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
