How to use step function in bidirection (Next and Previous) ? I write the database application that use SQLite v3.4.1 and I place two buttons "Next" and "Previous" for go forward and go backward of row. I found SQLite has only "sqlite3_step(stmt)" function that can do only go forward in "Next" button, but i not found the function for backward. In access database it can do bidirection by specified the dynamic cursor instead of forward only cursor, but in SQLite i don't know how to do like that.
so If you know how to go backward row please help me ? Thank you.