Hi all,
      I create a table like this:
             sqlite3_exec(db, "CREATE TABLE TBLNAME (ID INTEGER PRIMARY KEY
, NAME TEXT)", 0, 0,&zErrMsg);
      Then insert some records, the follow is the contents of this table.
            -------------------------------------
            ID                       NAME
            ==================
   (1)      1                         AA
   (2)      2                         BB
   (3)      3                         CC
   (4)      4                         DD
   (5)      5                         EE
   (6)      6                         FF
   (7)      7                         GG
            --------------------------------------

     Then may delete some records,
           -------------------------------------
  ID                       NAME
           ==================
   (1)    1                         AA
   (2)    3                         CC
   (3)    4                         DD
   (4)    6                         FF
   (5)    7                         GG
           --------------------------------------
   I want to find the Nth record, for example,when N=3 , I want to get this
record  : "4           DD" , N=5 : "7       GG" . The N value is given, and
how can do it fast?

                    Thanks
                    Yoky
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to