How: Persistant record order

From: Gary K (GaryK_at_discussions.microsoft.com)
Date: 11/08/04

  • Next message: Hugo Kornelis: "Re: How: Persistant record order" 
    Date: Sun, 7 Nov 2004 20:17:02 -0800

    Does anyone know a (relativly) easy way of keeping records in their created
    order? (or a specific order, and maintaining that order through
    additions/deletions/changes)
    I'm interested in a general method (ie, works for everything), but I'll use
    my specific example as explaination.
    The ExamText table holds the body text for a page, related to the text are
    the ExamQuestions, which hold the question text (& indicates single/multiple
    answer choices), and is related to the ExamAnswers table, which holds the
    answer text (& indicates if it is a right answer).
    What we have found is that the questions/answers are not retrieved in the
    order they were created, and this does tend to confuse a few people (some of
    the Q/A was ordered for a specific reason). What we would like to do is
    retrieve them in their created order (or at least a specific order).
    I know I can create an extra order column and sort by that in the select
    statements, but they will also be high-traffic tables, with a lot of
    creation/editing of records, and I would prefer not to create a lot of
    'ordering' code to handle the re-ordering of items.
    Does anyone know of an easier way? or have I hit the nail on the head the
    first time (and therefore I'm stuck with the extra work load)?

  • Next message: Hugo Kornelis: "Re: How: Persistant record order"