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

Re: Odbc and client library/drivers

Newsgroups	comp.databases.ms-sqlserver
Date	2012-09-21 03:10 -0700
References	(5 earlier) <XnsA0D3F197028B1Yazorman@127.0.0.1> <50cb24ed-7b00-4bd1-9de3-dc00553ea2bb@googlegroups.com> <XnsA0D4EF4453665Yazorman@127.0.0.1> <11c929ed-7994-4ef8-87af-5989e567bd01@googlegroups.com> <2bcb8b31-a822-4ce0-a97e-bd95aadd3588@googlegroups.com>
Message-ID	<6a38c299-ecef-479d-bcc2-d05d1e19546c@googlegroups.com> (permalink)
Subject	Re: Odbc and client library/drivers
From	björn lundin <b.f.lundin@gmail.com>

Show all headers | View raw

Den fredagen den 21:e september 2012 kl. 11:57:16 UTC+2 skrev bradbury9:
> > > > And here is a clearly a difference in opinion.
> > > > I do not see 'select *' as an error or as a problem.
> 
> get database data: select * from tablename where blablabla
> 
> for each row
>     for i = 0 to data.columns
>          excel.column[data.columname] = value --> BOOOOM
>     end for
> end for
> It worked fine for almost four years, until someone added a column to a table >without adding it to the XSLT. new column was not found in the transformation >file.

Hmm yes but that is something different. 
The code cleary states that is _treats_ ALL columns.
That is not my case.

We READ all columns into structs but that does not
mean the code is looping over all fields, _treating_ them.

When an addtion/change of the code is done, the data
is already in the struct, and no need to change the sql.
Or really, no need to worry about some 'lazy' progammer
taking a shortcut assuming the data is already read from the database.

1 crash/bug less :-)


But I respect your point of view.

--
Björn Lundin

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next 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