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

Reply via email to