You can add it to the select list as OID, ROWID or _ROWID_ or, if the
table has a column defined INTEGER PRIMARY KEY (but not INTEGER PRIMARY
KEY DESC) it'll also be this value. See:
http://www.sqlite.org/lang_createtable.html#rowid
Peter
On 2/10/2013 5:23 PM, [email protected] wrote:
After you do a retrieve from the database, how would to access the RecNo for
each record? I can get to all the fields but I don't know how to access the
record number that sqlite creates when it creates your record. I am not
looking for the last record number created.
I will be populating a ListView and I want to add the RecNo in the caption.
"SELECT * FROM TestTable"
~while(sqlite3_step(stmt) == SQLITE_ROW)
~{
~~sName = (char*)sqlite3_column_text(stmt, 0);
sLName = (char*)sqlite3_column_text(stmt, 1);
Thanks
___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
