>My point is:
>If you would have used something else instead of A-K&M in your example, the SQL Select would have given you an error that the SQL Column was not found in your datasession. You would have seen the error straight away and you would also deduct very quickly what the problem was. (I'm assuming that the Alias in SQL-SELECT for lcFile would never be an Alias of another workarea.)
Hallo Frank,
Sure, I would have seen the error right away if I had used some other alias. But the same is true if there had been some other, or no, table open in workarea 1. It really was all quite coincidental that the table in area 1 had a same named field. Coincidents happen, and there are many other, including 'good practice', situations that can cause extensive debugging sessions. And what 'good practice' should a programmer apply to prevent that the used many-chars alias is
not used elsewhere??
BTW, I'd like to close this 'good practices' part of the thread. If you like, you can continue in a new thread, ok?!
See also:
Re: 10 types of people Thread #
836301 Message #
838717
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
