according to the forward-only iteration through sqlite table records, i wish i could realize some kind of funtions like next(), prev(), move(), getbookmark() and setbookmark(), to bi-directionally iterate through table.
i searched through this forum of "cursor" question about sqlite. someone tell it can be get through the funtion sqlite3_get_table(), but memery overhead arises and has impack on speed! i read the orignal code source of the last version of sqlite, and find some funtion and struct about virtual table deal with cursor behaving as i mentioned above. but i don`t know what kind of relation between virtual table and the table storing the actual data i put into. further, i find some kind of funtion of btree api in sqlite, just like sqlite3BtreeCursor, sqlite3BtreeFirst, sqlite3BtreeLast, sqlite3BtreeNext, qlite3BtreePrevious, sqlite3BtreeMoveto, which is akind of what i want. but i do not know how far it is away from the behavior dealing with field data under the "table" framework! -- View this message in context: http://sqlite.1065341.n5.nabble.com/cursor-question-about-sqlite3-tp66263.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
