Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1306

Re: Odbc and client library/drivers

Show key headers only | View raw

> How about using views on the server on the same table - then you can 
> stick to using "SELECT *" in queries, but you can use different column 
> 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 
> on a view that intercept an action that makes excessively simple 
> 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 
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örn Lundin

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 10:48 -0700
  Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-18 21:57 +0200
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 13:24 -0700
      Re: Odbc and client library/drivers George Neuner <gneuner2@comcast.net> - 2012-09-19 11:46 -0400
      Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 21:16 +0200
        Re: Odbc and client library/drivers Gene Wirchenko <genew@ocis.net> - 2012-09-19 13:14 -0700
          Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:41 -0700
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:45 -0700
              Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:56 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 14:00 -0700
        Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:26 -0700
          Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 23:44 +0200
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:50 -0700
              Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-20 23:31 +0200
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 01:18 -0700
                Re: Odbc and client library/drivers bradbury9 <ray.bradbury9@gmail.com> - 2012-09-21 02:57 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:10 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:14 -0700
  Re: Odbc and client library/drivers rja.carnegie@gmail.com - 2012-09-19 16:57 -0700
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:58 -0700

csiph-web