• LCrawford (unregistered)

    I'll bet it is traced back to the frist number of an array being 1 instead of 0 in Microsoft Access VBA.

  • Industrial Automation Engineer (unregistered)

    off-by-one-error (like this frist post.)

  • Prime Mover (unregistered)

    "Now, this isn't particularly shocking, and honestly, probably wasn't even a terrible idea ..."

    You having a bubble?

  • BWill (unregistered)

    How does the Access database handle model year halves and quarters? And yes, that's a thing with cars.

  • RLB (unregistered)

    Typo: recnetly.

  • (nodebb) in reply to BWill

    Well actually it's a good thing they have it as a lookup table, and not an INT column, because it's trivial to add a row for "2022.5" and what not, but they would have been out of luck had they went with an INT column.

  • Sauron (unregistered)

    Wild guess: The case for the 2022 model was hardcoded in the code as a particular case.

    Now I'm worried. Does the code start use the ModelYearAbbr to find the ModelYear, or the other way around? In either case, it's a matter of adding or subtracting 2000, so the code could just do that on the fly rather then looking in the database. Of course, that solution would crash in year 3000, but hey, 1000 years should be enough to refactor the bad code and bad database, right? Right?

  • Yikes (unregistered)

    "Down that path lies an eldritch madness, a cosmic horror that would cause our very souls to bleed." Someone had an emo phase growing up! (or vampyre??)

  • (nodebb) 
    Post  Number
---- ------
1    1
2     2
3     3
4     4
5     5
6     6
7     7
8     8
9     Frist

    Frist!

  • (nodebb) in reply to Prime Mover

    This is common in data warehouses (though not in OLTP databases.) You'll have a DateDimension table that also has columns pre-computed for year, month, day, day of week, day of year, etc. That way you can just join a foreign key then filter quickly.

  • Abigail (unregistered) in reply to Sauron

    It crashes in 3000 because you cannot subtract 2000 from 3000?

  • I'm not a robot (unregistered) in reply to BWill
    How does the Access database handle model year halves and quarters? And yes, that's a thing with cars.
    Most likely not at all, and so what if it doesn't? Just because it exists doesn't mean the system *has* to support it, and if it's obscure enough that you have to tell people "yes, that's a thing", then there probably isn't much demand.
  • DeathBeNotLoud (unregistered)

    Smells like someone in 2004 thought "I'm sure someone will upgrade this in 18 years".

    I love finding code where it's not surprising at all that there is a bug, but it's completely bewildering that it worked for a year when it was clearly broken.

  • DeathBeNotLoud (unregistered)

    Smells like someone in 2004 thought "I'm sure someone will upgrade this in 18 years".

    I love finding code where it's not surprising at all that there is a bug, but it's completely bewildering that it worked for a year when it was clearly broken.

  • FrodoB (unregistered)

    Ah yes, the only thing more frighting than "This doesn't work, but it should work, what am I missing":

    "This works, but it shouldn't work. WHY DOES THIS WORK. WHAT AM I MISSING. WHAT WILL I BREAK WHEN I FIX THIS."

  • DJ Dizzy Spudplucker (unregistered) in reply to DeathBeNotLoud

    "Smells like someone in 2004 thought "I'm sure someone will upgrade this in 18 years" More like, "won't be my problem!"

    Back in 1994 working for a now-defunct big box retailer, we wanted to show a version number on the screen, based on release date. It used an Alpha for the quarter of the year, and two numerals for the day within that quarter. Would have worked for 6 1/2 years until Y2K. We went with it - the reasoning - "I won't be here then.."

  • (nodebb)

    There are undoubtedly a lot of guides, programs, and services available to students today that help them learn and achieve academic success. Term papers, research papers, essays, and dissertations, for instance, can all be written with a write my dissertation https://www.bestessay.com/write-my-dissertation/ . Although I'm not sure if using these services will increase pupils' understanding, each person has the freedom to choose

    Addendum 2022-09-29 19:16: There are undoubtedly a lot of guides, programs, and services available to students today that help them learn and achieve academic success. Term papers, research papers, essays, and dissertations, for instance, can all be written with a write my dissertation . Although I'm not sure if using these services will increase pupils' understanding, each person has the freedom to choose

Leave a comment on “Model Years”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article