select rowid, * from TestTable Tom
Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Follow us on Twitter: http://twitter.com/barefeetware/ Like us on Facebook: http://www.facebook.com/BareFeetWare ---- On 11/02/2013, at 11:23 AM, roystonja...@comcast.net 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" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users