Use the Sqlite row id. His Nerdship wrote: > 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
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
