Re: Generating SQL

From: Cristiano Sadun (cristianoTAKEsadun_at_THIShotmailOUT.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 13:54:00 +0000 (UTC)

mikharakiri_nospaum@yahoo.com (Mikito Harakiri) wrote in
news:8a529bb.0411181353.7855a736@posting.google.com:

> The suggestion that
> application developers have to rewrite any sql statements whenever db
> designer adds a column is ridiculous.

Not at all.

I've seen plenty of code doing "select *". Or "insert into values(...)".
That code will fail after adding a column.

Of course that SQL is crappy, but you're talking exactly of legacy code
whose quality is unknown.

Relevant Pages

  • Re: Generating SQL
    ... > application developers have to rewrite any sql statements whenever db ... > designer adds a column is ridiculous. ... There is no reason to ridicule people ...
    (comp.object)
  • Re: Generating SQL
    ... >> application developers have to rewrite any sql statements whenever db ... > Of course that SQL is crappy, but you're talking exactly of legacy code ... If language syntax has wrong constructs, ... Invent SOAP. ...
    (comp.object)
  • Re: How to write long string sentences
    ... > Whether or not a stored procedure was an option, ... > a data command object placed on an Component to manage my SQL statements ... > set properties of these with the properties window. ... > designer & property window of the component will allow you to use a visual ...
    (microsoft.public.dotnet.languages.vb)
  • Oracle Updates with DataAdapter failing
    ... it appears that the designer generated bogus code. ... drag/dropped the table onto my form the SQL statements seemed to be ... the colon character in front of the parameter name. ... into our client/server development tools way back in the early 90's). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login to FE as 2 different users?
    ... except that I have probably closer to 500 SQL statements in VBA ... > 3) Create RWOP queries on these tables that have the name that the table ... > That way you don't have to rewrite your SQL statements in code. ...
    (microsoft.public.access.security)