Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2015
    Posts
    2

    Unanswered: rows being reversed by itself

    hi all ! i keep searching everywhere and i cannot get around that !

    so lets say i have a table with 50 rows, so the id column goes from 1 to 50 of course. but then if select those 50 rows and delete them all and then enter 50 new rows it goes from 50 to 1 ! i do not understand how or why this is happening and its a huge problem since im displaying shows rows in a Xcode table view ! how do i fix that so its always going from 1 to 50 ?

    thank you very much for any help !

    tommy

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Include an ORDER BY clause in your SELECT statement.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2015
    Posts
    2

    Why is it happenning

    Hi thank you very much for your reply ! But how and why this is hapenning ! Just so i know ! I dont like fixing a probleme without knowing why it happened in the first place ! What is the logic behind that ?

    Thank you

  4. #4
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    its not a problem. Order is never guaranteed in any database system unless you use ORDER BY on your select.
    Dave

Tags for this Thread

Posting Permissions

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