Hi, I am converting a program from Paradox (stop laughing, please) to SQLite. Paradox has a useful feature where you can specify the actual index of a row in the table. This is handy when the table is displayed in a grid and you want the record corresponding to a row in that grid - you can just specify the index, say 28, of that grid row and it will get the record no 28 from the table. It spares the need for a SELECT statement, and is a lot more efficient. As a SQLite newbie, the only way I can see to do this is to read the whole table with sqlite3_get_table() and then get the required row from the returned array. This seems overkill when I just want a single record. Is there a more compact way of doing this? Thanks in advance etc. Sholto -- View this message in context: http://www.nabble.com/Any-concept-of-row-number-in-SQLite--tp22112862p22112862.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
