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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
