RE: Insert at a particular position in the detail list

From: Scott Anderson (sanderso..irvana.com)
Date: Thu Sep 25 2008 - 13:30:01 EDT

  • Next message: Øyvind Harboe: "Re: Problems with MS SQL Server and creating merger tokens"

    If you put a new entry in the middle of the list, it's still going to
    boil down to a vanilla INSERT. Since DB tables are FIFO, your row will
    jump to the end of the list the after a refresh.

    If order is important to your application, you'll have to come up with a
    way that the database will respect. That could mean, among other things,
    sorting on a field, or using relationships to daisy-chain the records
    like a linked list.

    This archive was generated by hypermail 2.0.0 : Thu Sep 25 2008 - 13:31:05 EDT