[AccessD] Ambiguous Name

Interesting approach Arthur and I can see why that maybe useful in doing
things that way.

I would say don't think there is a right or wrong way of doing this and we
all have our own preferences, I think the only 'crime' (for the want of a
better word - maybe 'mistake' (?)) is to be inconsistent with your approach.
The main aim I have on naming things in a certain way is to minimise risk.
By putting some details of what to expect in the object name I find it is
easy to chase down any issues. But of course that is just me.  Everyone
else's mileage will vary.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, 20 September 2011 9:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Ambiguous Name

First of all, I am semi-retired, after 25+ years in the trenches.
Second, I am an opponent of Hungarien (Simonyi) notation. I invented my own
school of notation, which I call (in homage to the aforementioned)
Post-Hungarian. In a nutshell this means:

frm_MyForm --> MyForm_frm. And so on for all objects in said project. Why
adopt this convention? Because all the objects related to, let's say,
Customer, are all sorted naturally, I can find everything related to
Customer easy as pie. At the end of the day, I am most interested in
retrieving said objects. I go further. I have suffixes including "_qs",
"qu", "qd" and "qi" and these mean "query select", "query update", "query
delete" and "query insert"/ The point being that the prefix "Customer..."
sorts the people according to what they affect, and from there I can work
out what is destined to do something to the underlying data.

Granted, this is only my opinion on how objects ought to be named. Smarter
people on this list might come up with superior schemes,

A.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com