Thanks for the reply. I meant android.database.sqlite.SQLiteOpenHelper . I'm using:
long android.database.sqlite.SQLiteDatabase.insert(String table, String nullColumnHack, ContentValues values) which returns a rowID for the new row. This works the first time but not subsequent. I'll try using the direct approach - after I learn how to do this! On Feb 23, 6:14 pm, Brion Emde <[email protected]> wrote: > I'm confused with the terminology you're using. > > What is Data Base Helper? There are a couple of them: > SQLiteOpenHelper; SQLiteQueryHelper and just the plain old database. > Your SQLiteOpenHelper can create stuff when you create your database, > like if you need a table pre-populated. > > The QueryHelper is for helping you build queries. Those are the > helpers that I have used. > > When I want to insert, delete or update a row in a table, I talk to > the SQLiteDatabase object itself. > > On Feb 22, 10:11 pm, Paul <[email protected]> wrote: > > > > > I have a database that works fine to create a new row the first time > > after I start the application, but subsequent times, data base helper > > returns the same rowID and does not store a new row. It doesn't help > > when leaving or returning to an activity or if I stop and start the > > database. Do I need to do something to tell insert to ... insert? I > > can work around by restarting the app, but there must be something > > simple I'm missing. > > > I've used the Notepad example database as my starting point. > > > Any help would be appreciated. > > Thanks, > > Paul -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en

