thanks, Simon Slavin-3!
it is good idea to use " SELECT rowid FROM myTable WHERE rowid >
*[current_rowid]* ORDER BY rowid LIMIT 1 " . but the key question is about
the " current_rowid": how to get the value of rowid as the way as
extracting other field value!!
for example,
... ...
int rowiddd = -1; // to store rowid of the specific record
lpctstr sql = _T("select * from student"); // deal with all fields in the
talbe
sqlite3_prepare16_v2(&db, sql, -1, &stmt, Null);
rc = sqlite3_step(stemt);
while(SQLITE_ROW == rc)
{
.... // get to a record in the table, maybe the first, or maybe the other
.... // here get the ROWID of this record and store and mark it in rowidd
.... // move on and do sth with record
.... // something happens and it is necessary to move to the record marked
by rowiddd. may be with the
// sql query: "SELECT rowid FROM myTable WHERE rowid = rowiddd".
.... // here we again get to the marked record and do sth with it.
}
... ...
i am not familar with SQL query, so bother you to give some idea! thanks!
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/how-to-move-around-records-in-sqlite-as-the-way-as-in-CDaoRecordset-of-MFC-tp66191p66268.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
