Pointless debates on the finer points of naming your objects (moved from Combo Box Requery thread)

Good article, though I was already aware of the differentiation between
Systems & Apps Hungarian (though I can never remember their formal titles
until I re-read articles such as that one...the names just never made sense
to me).

Going back to the "tbl" concept, though, at some point in this long chain of
messages over multiple threads, I seem to remember stating that I only use
"tbl" for generic tables that have no other logical grouping within my
database (or code, or whatever it is I'm looking at), and that I tend to
group and name tables by logical function ("acct", "resp", etc.)
otherwise...that it seemed a little redundant to name everything of a
certain object type or data type with the same prefix. Isn't that basically
what the article is advocating?

I *do* consider Systems Hungarian to be a perfectly valid alternative for
those that find it's useful to them, though for what I do, I find it a
little limited in its own right. My personal preference is to use a hybrid
of systems & apps when coding, where the first lower-case prefix is
descriptive of the data type (with reasonable exceptions...I don't know
ANYBODY who uses something like lngHWnd), and the first upper-case prefix is
descriptive of the logical grouping, (i.e. strAcctFilename, which is very
obviously a string relating to an account, and is a file name). But there
are those who prefer Systems Hungarian, and as long as they keep it
localized to their own code/database/whatever and don't try to impose it on
mine, that's fine. (As you can imagine, I was NOT best pleased with the Web
developer who went and copied all my stored procedures that started with
"web" to indicate they were used on the Web to a simple "usp" prefix. Who
on earth ever gave System Administrator privileges to a *student* web
developer?!?)

Anyway, all things considered, I think we mostly just misunderstood each
other from the start of this conversation. You know what the say about
assumptions!



Rob

"Tim Ferguson" wrote in message
...
For a good description of the history of "systems Hungarian" and its
misapplication see Joel on Softwa

http://www.joelonsoftware.com/articles/Wrong.html

Tim F