Re: Simple (?) question about views

From: <tgp_at_mci2000.com>
Date: Wed, 05 Aug 1998 20:49:49 GMT
Message-ID: <6qaghd$5iq$1@nnrp1.dejanews.com>

Ah. No doubt you are correct. Somehow I couldn't see the fact the the very "create view" part of the statement was missing. Thank you for assuring me I'm not crazy.

In article <01bdc096$7bef7540$186be288_at_ato-10111>, "Dennis Wetherell" <dwether_at_mail.arco.com> wrote:
> You are only printing out the select statement for the view. You are not
> printing the actual view definition. Most likely the value QTY_VCHR is
> renamed as QTY_INVOICED in the view definition.
>
> E.g. create view PS_VCHR_LN_PO_VW (...,
> ...,
> QTY_INVOICED,
> ...)
> as select (...,
> ...,
> L.QTY_VCHR,
> ...) from PS_VOUCHER_LINE L, PS_VOUCHER V ...
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 05 1998 - 15:49:49 CDT