Table names for permanent tables have no specific prefix, but I tend to
use a common front end for keeping track of module tables, such as
Invoices
InvDetails
InvBalance
Temporary tables are tAgingReport - lower case t in front of the table name.
Columns, where appropriate are prefixed as in CustID, CustName,
CustAddr1 CustAddr2, CustCity ...
Permanent views I prefix with vw as in vwCustomerBalance
I hate underscores. I use upper and lower case as shown above.
Variables unique to a form I start with f as in fInvNo or fCustID
Variables that are global, but get cleared are vVarName
Variables that are permanent for a session I prefix with x as in xUserName
Component IDs I usually do the field name prefixed with a c - cCustID,
cCustName, etc.
FWIW
We all have our own ways of keeping things lined up.
Albert
On 20/02/2012 3:32 PM, Bruce Chitiea wrote:
All:
Any feelings one way or the other about 'prefixed' object naming
conventions?
... such as:
tb_<tablename>
tt_<temptablename>
vw_<viewname>
fm_<formname>
rp_<reportname>
Over time, is this helpful in building/maintaining code, or just extra
typing?
Thanks,
Bruce Chitiea
SafeSectors, Inc.
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
