sqlite_sequence is an internal table used to manage autoincrement columns http://www.sqlite.org/autoinc.html
can you post a code sample showing your data access? On Sat, May 19, 2012 at 3:52 PM, Chris_M <[email protected]> wrote: > > I'm building an app that needs to use a pre-existing SQLite database > already > populated with data. Right now I'm just working on reading the data and > displaying it in a UITableView. (I'm using SQLite-Net in my code, just > FYI.) > > I have created the database, and I created a table called "CountyInfo" in > the database, and I have imported all the relevant data. Everything looks > ship-shape. > > When I compile and test my code, it finds the database just fine, but for > some reason it's not seeing the "CountyInfo" table that's already in there. > Instead, it creates a new, second table in the database called > "sqlite_sequence", which has one record with three fields: rowid (value: > 1), > name (value: CountyInfo), and seq (value: 254). (My original "CountyInfo" > table is still sitting there in the database with all its data intact.) The > data from the original CountyInfo is not displayed in my table view, > presumably because the app isn't seeing or reading the table for some > reason. > > What in the world is going on? > > I can post the relevant code from my project if necessary, but does anyone > know what is happening just based on the above information? > > > --Chris M. > > > -- > View this message in context: > http://monotouch.2284126.n4.nabble.com/SQLite-database-confusion-code-not-reading-table-tp4646271.html > Sent from the MonoTouch mailing list archive at Nabble.com. > _______________________________________________ > MonoTouch mailing list > [email protected] > http://lists.ximian.com/mailman/listinfo/monotouch >
_______________________________________________ MonoTouch mailing list [email protected] http://lists.ximian.com/mailman/listinfo/monotouch
