Hmmm ... I just submitted this as a bug - two different tables, same column names but the computed columns have different expressions.
CREATE TABLE `Computed1` + (`col1` INTEGER , + `col2` INTEGER , + `col3` INTEGER , + `colComputed`= + (col1+ col2) INTEGER ) CREATE TABLE `Computed2` + (`col1` INTEGER , + `col2` INTEGER , + `col3` INTEGER , + `colComputed`= + (col2+ col3) INTEGER ) The RDCC response is that it was that way in 6.5++ - which is true so it won't be treated as a bug. But why do I think it shouldn't be that way? I always was under the impression that the R:BASE engine was set up to prevent this. I'd be interested in other's opinions on this as to why it's NOT that way or why it SHOULDN'T be that way. Sami ------------------------------------------ Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 mailto:[EMAIL PROTECTED] www.softwaremgmt.com
