Knowledge can't be divided, only multiplied
It's the quality of the team that makes a Q&A site work
Sunday 28 December 2008, 10:58 AM
Ab-normalization at Experts Exchange - part 8
Trying to use CASE statement in ADO execute command
It almost gets boring as this is another "classic" example of redundant data trouble.
Why have a table field filled with the same value as another field when empty?
The first question I would ask before advising such a questioner is why a field is occurring twice in the table. The tell tale field name "Salesperson2" indicates normalization hasn't been applied.
But, you're having a bad day when you're advised by the #1 MS Access expert at Experts-Exchange. This "expert" will give you as solution the code to update the field in the table and won't mention the data redundancy and the trouble this can cause. Obviously he's never worked with databases in the real world as when there's a need for a "Salesperson2", it's almost sure that in the near future a "Salesperson3" will be requested by the users and all code can be changed, etc., etc.
Is the questioner helped by this ? Yes, in the short term, but it's sure he'll be back and that makes EE happy as they will continue to collect their $$'s.
For smarter people there are sites like bytes.com where the membership is for free and the experts are cooperating to provide the best answers.
Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23996147.html)
PreviousComments on this post
Some questioners are novices so they dont understand. I expect they see him as #1 so think he is actually good. If an expert comes along to give proper info, chances are the novice wont use it as it may seem too complicated and the simple pathetic answers offered by capricon1 tend to be taken
Here is your chance to put faces to the names
http://www.ee-stuff.com/angeliii/index.php?mypage=GALLERIES&gallery_folder=galleries/ee_conference_2008/&gallery_image=&menu=GALLERIES
Only selected people were invited, I wonder if capricon1 was one of them.
Thanks for the link PepperPots, interesting to see how the EE revenues are spent to bind the "happy few" :-)
Capricorn1 wasn't there as his MVP image ("https://mvp.support.microsoft.com/profile=47F8E46D-7AB1-45B7-B96D-FB8C2223CDFF") gives no match.
Nic;o)
Private message disabled
