January 5th, 2013, 05:44 PM
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.
January 16th, 2013, 05:50 AM
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.
January 16th, 2013, 06:54 AM
There is no such thing as "the bottom" or "the top" of a table.
Originally Posted by Medi-Pro
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.
Tips on how to ask better questions: