Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    texte or number, am i Just dumber (2003)

    The old policy in our office was only to use number codes for variables that required numerical treatment like sum or average, otherwise use text to code variables.
    So the city code would be "06000" for Montreal, "03000" for Quebec City etc. Now the mangers want to change all our data bases to numeric codes 6000 for Montreal, 3000 for Quebec City etc. Is there a reason to use either text or numeric codes ? Which processes easier?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: texte or number, am i Just dumber (2003)

    There's nothing wrong with the old policy. Perhaps the only advantage of using numeric data types is that in general, they take up less space: a Number (Long Integer) field or variable takes up 4 bytes, whatever the actual value is (up to over 2 billion), whereas a text value such as 03000 takes up 6 bytes (5 characters, plus one count byte). A disadvantage of converting is that you'll have to check all queries, forms and reports to see whether they still operate as intended. This could cost a lot of time (=money)!

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: texte or number, am i Just dumber (2003)

    If I can only get them to cost it out. Thanks.

Posting Permissions

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