>You mean code that should work with any database table with tables than can have any names in there ?
How about the situation where you inherit an existing application/database.
>I'm not sure what kind of programs you're are talking about then. As I stated before I avoid the situation where I can have fields and variables with the same name by having a three character prefix plus an underscore for the fieldname. For variable I always begin with a one char type prefix.
You're probably in the minority doing this. Everyone I've talked to about this in the past five years doesn't do it.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer