[sqlite] cursor question about sqlite3
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
Re: [sqlite] cursor question about sqlite3
genliu777 doityth...@163.com wrote: 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. http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] cursor question
Cursors as such are not implemented. You can achieve the function of a cursor from Sqlite with some thought. Jim Crafton wrote: Does the latest version of sqlite have cursors? If so, where might I find docs on using them? Thanks Jim C - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] cursor question
Does the latest version of sqlite have cursors? If so, where might I find docs on using them? Thanks Jim C - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] cursor question
On 12/11/06, Jim Crafton [EMAIL PROTECTED] wrote: Does the latest version of sqlite have cursors? If so, where might I find docs on using them? No; however, the API returns query results iteratively, as if it were an implicit forward-only cursor. - To unsubscribe, send email to [EMAIL PROTECTED] -