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.
does that mean i wont be able to locate the db file ? I saw a data
folder in android sdk /platforms /1.5/ but it does not follow
structure after that like data/pkg name/databases
and there is no data folder generated in bin folder of my workspace.
the curious situation is, i create records
Jags wrote:
does that mean i wont be able to locate the db file ?
On the emulator, you should have no problems. On a device, though,
security restrictions will prevent you from finding it.
I saw a data
folder in android sdk /platforms /1.5/ but it does not follow
structure after that like
A really nice feature is that the SQLite db is binary compatible on
all different platforms so you can copy the database.db file to your
computer and use any SLQLite tools to look and test the db.
So you could then connect to the db thru jdbc and use for example
eclipse with the sql tools and
Thanks you seem to know everything.
i have named it differently, i just wrote it MyID not to publish too
many info in a public forum, copywright you know. :)
i observed, the pk value is all blank...
while putting in COntentValues, I am putting nothing for MyId, as I
expect it to be auto
and you dont have an answer for last part ? pk value in alarm intent ?
How can it be ?
regards
On Dec 14, 3:02 pm, Mark Murphy mmur...@commonsware.com wrote:
Jags wrote:
does that mean i wont be able to locate the db file ?
On the emulator, you should have no problems. On a device, though,
Jags wrote:
i have named it differently, i just wrote it MyID not to publish too
many info in a public forum, copywright you know. :)
It is more that _ID will work better if you use CursorAdapter.
CursorAdapter needs a unique key named _ID. You can always rename the
column in your query (SELECT
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:
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 mmur...@commonsware.com wrote:
Jags wrote:
and you
9 matches
Mail list logo
