Results 1 to 4 of 4

Thread: [RESOLVED] Prefixes

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2006
    Posts
    125

    Resolved [RESOLVED] Prefixes

    I was wondering if there was a right and a wrong way of showing prefixes.
    Is there a convention?

    I know alot of people use 3 letter prefixes. Is this the standard, if so can we create a list of them so me and i'm sure other people can refer to them.

    or

    Do prefixes not have a standard IE. can I right tableSomething instead of tblSomething and not be considered conventionally wrong?

    Thanks. Emdiesse.
    Emdiesse

  2. #2
    Banned
    Join Date
    Nov 2005
    Posts
    2,367

    Re: Prefixes

    It's just something you use for consistency. It doesn't matter as long as you're comfortable with your prefix, you can easily identify what it means and the rest of your team using the same conventions. Here's my quick list:

    tbl = Table
    str = String
    sint = INteger (16bit)
    int = Integer (32bit)
    lint = Integer (64bit)
    dbl = Double
    txt = TextBox
    lb = ListBox
    lbl = Label
    sql = SQL Data Object (usually followed by a Cmd or Adap or something)
    obj = Object
    dtm = Date/DateandTime
    chr = Character
    frm = Form
    btn = Button
    dg = DataGrid
    dcm = Decimal

    That's just a quick list. Some of them I make up on the spot, but those ones are pretty consistent. I also use "_" before the prefix to denote anything that's private (variables and methods).

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Prefixes

    Here's the official list from MS on VB Hungarian Notation:

    http://support.microsoft.com/kb/q173738/

    and another link:

    http://www.gregleg.com/oldHome/hungarian.html

    Here's what Joel has to say on it...

    http://discuss.fogcreek.com/joelonso...w&ixPost=35396

    I like boo for boolean - most people do bln...

    Consistency is more important

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jan 2006
    Posts
    125

    Re: Prefixes

    OK. Thanks.

    I was just struggling to think of one for a sub form :P
    Emdiesse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width