On 25 Dec 2012, at 3:22pm, genliu777 <doityth...@163.com> wrote: > // sql query: "SELECT rowid FROM myTable WHERE rowid = rowiddd".
If you already know that rowid = rowiddd then there's no point in doing the SELECT. You already know the answer. If you want to find the line before or the line after this one just use SELECT rowid FROM myTable WHERE rowid > rowiddd ORDER BY rowid LIMIT 1 SELECT rowid FROM myTable WHERE rowid < rowiddd ORDER BY rowid DESC LIMIT 1 if you want more than one row, change the LIMIT clause. Once you know which rows you're interested in, you can use something like SELECT * FROM myTable WHERE rowid = rowiddd to find the values you're going to want to print or show on the display. > i am not familar with SQL query I think this may be your problem. You could spend a couple of hours learning how to use SQL just from reading random SQL tutorial web pages. This may help you figure out which questions to ask or you may not need to ask any. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
