I solved the problem, but I'm not sure why it was a problem. In case anyone is interested:
A menu selection calls a dialog box which inserts the new row. It worked only the first time it was selected after the program starts. None of the variables change after the first time. I moved the identical insert code from the dialog into the menu selection code and it works every time. The user doesn't have a confirm dialog, but I'm not sure why I thought it was needed in the first place. Any idea why this was happening? Paul On Feb 23, 8:15 pm, Paul <[email protected]> wrote: > On further review, I think I am using the database object to insert a > row. > return mDb.insert(DATABASE_TABLE, null, initialValues); > where mDb is the database returned by getWritableDatabase. > > Any ideas why this would work the first time, but not create a new row > the next time? > It returns the same rowID each time until I restart. > > On Feb 23, 7:16 pm, Paul <[email protected]> wrote: > > > > > 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
