[AccessD] Naming Conventions

Porter, Mark MPorter at acsalaska.com
Wed Aug 4 12:30:19 CDT 2004


No flames here, I have made the same change to my naming convention as well.

It started with Report-Subreports and Form-Subforms, I was tired of fighting the prefix to find all sub objects to the main object.

Mark

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of 
> Arthur Fuller
> Sent: Wednesday, August 04, 2004 8:41 AM
> To: AccessD
> Subject: [AccessD] Naming Conventions
> 
> 
> After two decades of propounding standard Hungarian notation, I am now
> dead set against it, for two reasons:
> 
> A) You have to read past the prefix to find out what anything relates
> to. IOW, you increase noise at the expense of signal.
> B) All objects named thus sort poorly. How does it help you 
> if every cbo
> is prefixed "cbo"?
> 
> For the past year or so I have used what I call the "object-action"
> naming scheme. It uses Hungarian notation but as suffix not 
> prefix. This
> preserves the sort order in a meaningful way. A couple of examples:
> 
> CustomerInsert_ap - suffix means application procedure (as opposed to
> system procedure)
> CustomerSelectByName_fnt - user-defined function that returns 
> a table of
> customerIDs and names sorted by name (SQL 2000+ only)
> CustomerFilter_cbo - combo box that filters the form by selected
> customer (i.e. show only the orders placed by selected customer)
> 
> Perhaps the main reason that I have moved to this convention 
> is the ease
> of teaching it to a new hire, and letting her find her way around the
> database quickly. "Look for the object of interest, followed by the
> action of interest, and know what you're dealing with by the suffix."
> 
> In Access 2002+, this convention is especially profitable, because a
> single "Queries" tab houses sprocs, UDFs and views. Prefixing them all
> with standard Hungarian prefixes muddies the water, IMO. My convention
> lets you type "C" and immediately go to all the "Customer" related
> stuff. Then you can quickly deduce what's available for 
> re-use, and what
> sort of object it is.
> 
> Given the overwhelming devotion to standard Hungarian 
> notation, I expect
> this message to cause lots of flames and rebuttals. That's why we're
> here, after all :)
> 
> Arthur
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

***********************************************************************************
4/8/2004
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS





More information about the AccessD mailing list