Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

by wardk (Deacon)
on Nov 29, 2000 at 01:02 UTC ( #43768=note: print w/ replies, xml ) Need Help??


in reply to Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

As my Oracle and SQL Server DBA's have told me...Do not assume that column positions will ever be correct. This is especially good advice with INSERTS where assuming position will just flat out get you in trouble eventually, especially if the table structure is known to be dynamic (Simply adding a new column will void a working positional insert). In fact I believe SQL Server is guaranteed to NOT be reliably accessible by column "position".

As far as these type of changes. It's not very often that "labels" are changed on any real database system I've ever dealt with. At least not after they've gone into Production, and not without notice to the development teams using them.

Hopefully you are not at the mercy of someone modifying your tables without the benefit of at least an informal "heads up".


Comment on Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://43768]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (13)
As of 2014-09-18 13:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (115 votes), past polls