select foo.saledate + cast (foo.repeatinterval as interval day)
from foo

ElevateDB Error #700 An error was found in the computed column expression at line 1 and column 9 (Invalid expression . found, table qualifier not allowed)

I get the error message on both instances of foo. Really not allowed?

I get the same thing.  But if you declare a table alias in the FROM clause,
you can use the alias instead.

Try this:
 select f.saledate + cast (f.repeatinterval as interval day)
 from foo f


David Cornelius
Cornelius Concepts

Jeff,

<< ElevateDB Error #700 An error was found in the computed column expression
at line 1 and column 9 (Invalid expression . found, table qualifier not
allowed)

I get the error message on both instances of foo. Really not allowed? >>

I think this has been fixed:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.06&incident=3526

--
Tim Young
Elevate Software
www.elevatesoft.com