Re: Why can't I with a view (calculated column)

Posted in 1992

Dave Snyder — Fri, 24 Apr 92 22:37:33 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting Mark Garrett... > > Why can't I create a view with a calc column > > create view tst> as > select ship_charge - totval cout > from orders > where ship_charge > 0; Try this... CREATE VIEW tst (cout) AS SELECT ship_charge - totval FROM orders WHERE ship_charge > 0; DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.5 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com