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

Re: Odbc and client library/drivers

Received	by 10.224.207.197 with SMTP id fz5mr3336985qab.3.1348222254513; Fri, 21 Sep 2012 03:10:54 -0700 (PDT)
Received	by 10.236.139.196 with SMTP id c44mr569502yhj.17.1348222254468; Fri, 21 Sep 2012 03:10:54 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!l8no2498159qao.0!news-out.google.com!e10ni833245qan.0!nntp.google.com!l8no2460016qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Fri, 21 Sep 2012 03:10:54 -0700 (PDT)
In-Reply-To	<2bcb8b31-a822-4ce0-a97e-bd95aadd3588@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> <XnsA0D2DF54CB785Yazorman@127.0.0.1> <4486daa1-575b-4713-9ca5-f4c8654eb9c8@googlegroups.com> <XnsA0D3D87BB2DB5Yazorman@127.0.0.1> <3fe97e67-bae3-423e-9a1d-bdb938e48e7d@googlegroups.com> <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>
User-Agent	G2/1.0
MIME-Version	1.0
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>
Injection-Date	Fri, 21 Sep 2012 10:10:54 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1315

Show key headers only | 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