Re: Views (again) in 8.1.7
From: Sandeep Gupta <sandeep_bpl_at_yahoo.com>
Date: 16 May 2002 01:57:23 -0700
Message-ID: <c89fe0be.0205160057.6f1c686a_at_posting.google.com>
Date: 16 May 2002 01:57:23 -0700
Message-ID: <c89fe0be.0205160057.6f1c686a_at_posting.google.com>
The Query
select f1d1,"tot" from v_tot;
will solve your problem.
It looks like that aliased columns in views need to be accessed using alias name as a string and not as a column.
Cheers
Sandeep
"Maarten" <mmg_brouwers_at_hotmail.com> wrote in message news:<oPzE8.31715$48.2542923_at_zwoll1.home.nl>...
> Hi All,
>
> I looked in the archives but found no solution for my simple problem.
> I receive an error when I select the TOTAL column from my view.
> How can I resolve this???
>
> create view v_tot as select fld1,fld2+fld3 "tot" from table1;
>
> select fld1,tot from v_tot;
>
> the error is on: tot
>
> All help is greatly appreciated.
> Maarten
Received on Thu May 16 2002 - 10:57:23 CEST