Re: Stored Proced. in View?
Try using the supported notation:
SELECT 1+2 three FROM Systables WHERE tabid = 1;
CREATE VIEW three(three) AS
SELECT 1+2 three FROM Systables WHERE tabid = 1;
SELECT * FROM three;
As I noted in a previous email, you cannot use display labesl or column
aliases in all contexts -- the primary one being for computed results such
as three above, or aggregate functions (or, I assume, stored procedures),
etc.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
>From: storm@aztec.co.za (Storm Software)
>Date: 12 May 1995 18:10:35 +0200
>X-Informix-List-Id: <news.13832>
>
>Ignore my question. The bug seems to be with derived values and views.
>
>e.g. select 1+2 three from table
>
>works fine but try it as a VIEW and the thing moans all over the place.
>
>A reason please Informix?