oh ! I got the point why you were referring to _id. But can't I do like "SELECT MyId as _ID from My_Table" ? this is throwing (9165): column '_id' does not exist error, even though this query just runs fine in command line.
your way of "SELECT _ID=MyId from My_Table" gives invalid query exception. this also does not run on console . regards On Dec 14, 3:54 pm, Jags <[email protected]> wrote: > Thanks a ton, brilliant answer and to the point. > > MyId INTEGER PRIMARY KEY AUTOINCREMENT > > is the way to go. I am amused how auto_increment did not give any > error and created the table for me earlier ! > > regards > > On Dec 14, 3:25 pm, Mark Murphy <[email protected]> wrote: > > > Jags wrote: > > > and you dont have an answer for last part ? pk value in alarm intent ? > > > How can it be ? > > > Use an int extra (e.g., putIntExtra()). > > > -- > > Mark Murphy (a Commons > > Guy)http://commonsware.com|http://twitter.com/commonsguy > > > Android Training in Germany, 18-22 January 2010:http://bignerdranch.com > > -- 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
