Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Simple interval question |
Mon, Jan 23 2012 9:24 PM | Permanent Link |
Jeff Dunlop | 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? |
Tue, Jan 24 2012 2:49 AM | Permanent Link |
David Cornelius Cornelius Concepts | 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 |
Wed, Jan 25 2012 11:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |