#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0

    Wink Inserting Database Records


    I have realized that Absolute Database with Delphi7, when inserting records, it places the record recently inserted
    On the bottom of the table list. How can I insert a record to be at the top of the table list.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Location
    Pretoria, South Africa
    Posts
    3
    Rep Power
    0

    Insert


    How much resources can be spend on it, because you can insert the row in a temp table then insert all the other rows in the same temp table. Clear the original table and load all the rows from the temp table into the the original table.

    Or if you only want it to be 1st on selects I think you can specify some of the indexes maybe in desc order.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by Medi-Pro
    I have realized that Absolute Database with Delphi7, when inserting records, it places the record recently inserted
    On the bottom of the table list. How can I insert a record to be at the top of the table list.
    There is no such thing as "the bottom" or "the top" of a table.

    Rows in a relational table are not sorted. Picture them as balls in a basket.

    If you need them in a specific order, use an ORDER BY when selecting them.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo