First and last record confusion

Results 1 to 2 of 2

Thread: First and last record confusion

  1. #1
    Goran2 Guest

    Default First and last record confusion

    I use access database and with sql string: <BR>"insert into table1 (a,b) values (&#039 1&#039, &#039 2&#039)"<BR>I&#039m adding new records to my database. That works fine, but, the new records are placing at begining of my table, not on the end. Why is that? I need to put new records on the end of the table.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: First and last record confusion

    why exacly? access (and all relational databases for that matter) depend on the fact that the rows within a table are unordered in storage. if you need to get records out in the order they were put in create an extra database column called CREATED or something, of type datetime and with default value GetDate().(not too sure what the access equivalent of SQL Server GetDate() is, but it must have one)then, when you fetch the data, use ORDER BY CREATED ( & ASC or DESC, depending on which way around you want it ordered).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts