Received: by 10.224.207.197 with SMTP id fz5mr1013921qab.3.1348131500735; Thu, 20 Sep 2012 01:58:20 -0700 (PDT) Received: by 10.52.28.83 with SMTP id z19mr106199vdg.20.1348131500702; Thu, 20 Sep 2012 01:58:20 -0700 (PDT) Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!i6no84448qas.0!news-out.google.com!t12ni2384qak.0!nntp.google.com!i6no63545qas.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Thu, 20 Sep 2012 01:58:20 -0700 (PDT) In-Reply-To: <6e3349a4-60ed-451d-b7bf-3365ff488a74@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=83.145.50.10; posting-account=3_reEwoAAAC163IAIrx427KYmwahFuh9 NNTP-Posting-Host: 83.145.50.10 References: <94298aed-7cbb-41f8-a155-c4632fc9db35@googlegroups.com> <6e3349a4-60ed-451d-b7bf-3365ff488a74@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <9e19484b-dfc1-458a-a76e-7d0eff554229@googlegroups.com> Subject: Re: Odbc and client library/drivers From: =?ISO-8859-1?Q?bj=F6rn_lundin?= Injection-Date: Thu, 20 Sep 2012 08:58:20 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Received-Bytes: 2902 Xref: csiph.com comp.databases.ms-sqlserver:1306 > How about using views on the server on the same table - then you can=20 > stick to using "SELECT *" in queries, but you can use different column=20 > orders on the same table in different views. In MS SQL Server, > I suppose probably in Oracle as well, you can also INSERT, UPDATE, > and DELETE on a view. Yes, however only the client uses views, and the client can not update the = DB. > Also, if your elderly ODBC tool is upset by some modern data types, > then you could use views so that those columns either don't appear, > or are CONVERT-ed to something more digestible. That is no problem. The datatypes we use are present already, but for XML-type. But this is so different from Oracle's version that we see no common denominator. So we use varchar to store the xml, and bring it out from the db, and we parse that string, either with SAX or with Xpath, within the Ada code. > For INSERT etc., in such a case, you may be able to define triggers=20 > on a view that intercept an action that makes excessively simple=20 > assumptions about the nature of a table where you have actually > used a view, and, instead, the trigger performs complicated data > operations that your client program doesn't need to control directly. Hmm, yes, but all business logis is in Ada. It will be a nightmare to implement the same logic in both T-sql and pl/sql we have 1 or 2 trace triggers, that copies a record when it changes to a=20 trace table. That is bad enough to implement twice. The reason to have that in trigger code is that we catch events we might miss otherwise. Thanks for the suggestions though -- Bj=F6rn Lundin