Article View: borland.public.interbase.ibconsole
Article #28Re: Views
From: Craig Stuntz TeamB
Date: Tue, 12 Feb 2008 14:43
Date: Tue, 12 Feb 2008 14:43
16 lines
2135 bytes
2135 bytes
Jeff Overcash (TeamB) wrote: > For Views all the fields come back as read only even with triggers on > the view. This means I have to do more work to determine views and > determining what fields actually map to a real underlying field. Provided that the VIEW is updateable, IB allows any field in a VIEW to be used in an UPDATE statement, whether or not it maps to an underlying field. Those which don't are simply ignored. So it's probably correct to make them all read/write in this case. -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Everything You Need to Know About InterBase Character Sets: http://blogs.teamb.com/craigstuntz/articles/403.aspx
Technical Details
Message-ID:
<47b1be9f$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<47aaf9db@newsgroups.borland.com> <47ab68f8$1@newsgroups.borland.com> <47ab7bd6$1@newsgroups.borland.com> <47ab7f19$1@newsgroups.borland.com> <47ab87e9$1@newsgroups.borland.com> <47acbae4$1@newsgroups.borland.com> <47addaa8$1@newsgroups.borland.com> <47adffcd@newsgroups.borland.com> <47ae75a0$1@newsgroups.borland.com> <47af6d3b$1@newsgroups.borland.com> <47b10898@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: f4565,e521c44578fd5f2e X-Google-Attributes: gidf4565,public,usenet X-Google-Language: ENGLISH,ASCII From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: Views Newsgroups: borland.public.interbase.ibconsole References: <47aaf9db@newsgroups.borland.com> <47ab68f8$1@newsgroups.borland.com> <47ab7bd6$1@newsgroups.borland.com> <47ab7f19$1@newsgroups.borland.com> <47ab87e9$1@newsgroups.borland.com> <47acbae4$1@newsgroups.borland.com> <47addaa8$1@newsgroups.borland.com> <47adffcd@newsgroups.borland.com> <47ae75a0$1@newsgroups.borland.com> <47af6d3b$1@newsgroups.borland.com> <47b10898@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.18.1.9 X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 64.199.116.234 Message-ID: <47b1be9f$1@newsgroups.borland.com> Date: 12 Feb 2008 07:43:27 -0700 X-Trace: newsgroups.borland.com 1202831007 64.199.116.234 (12 Feb 2008 07:43:27 -0700) Lines: 16 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail