>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.