Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.lang.java.programmer Subject: Re: Where to put the return Date: Mon, 21 Aug 2017 22:33:50 +0200 Lines: 31 Message-ID: References: <87zib6zeup.fsf@munus.decebal.nl> <87y3qlnyvj.fsf@munus.decebal.nl> <87bmnbj09u.fsf@munus.decebal.nl> <87o9rbh9lv.fsf@munus.decebal.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net PmAwbElUp4kO9qfUNInX/ALJHrGFou8jHPdey9gdYVijrYbp0= Cancel-Lock: sha1:WPN3AY7lxklZAU22Lfjx2pYJesU= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 In-Reply-To: <87o9rbh9lv.fsf@munus.decebal.nl> Content-Language: en-US Xref: csiph.com comp.lang.java.programmer:37332 On 19.08.2017 17:15, Cecil Westerhof wrote: > Robert Klemme writes: >> What does that have to do with accessing via index or name? You are >> talking about changing queries because of changed schema. But that does >> not necessarily have effects on the layout of the ResultSet. > > Because I have seen to many cases where coders did something like: > SELECT * > FROM myTable > > You could say that when you use all fields that is not a problem, but > even then I would not use it. But others do. So you use an even worse habit (actually something commonly recognized as "should be avoided altogether") as argument against some completely legitimate approach. I think you have the priorities wrong in this case. > Also if you use the wrong variable in your getQuery the change you get > an error (what you should want) is bigger with a accessing by name as > by index. Yes. Cheers robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/