Hi

I'm todolist 2 Chapter 5 in emulator(The droid don't have permission),tryng to access de

todoItems from the database(data/data/com.paad.todolist/databases/todoList.db

using ADB shell sqlite 3.
I openned the database but is empty???


Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\John>adb
C:\Users\John\Desktop\Android 1.5\android-sdk_r3-windows1\android-sdk-windows\tools

adb -s emulator-5554 shell

drwxrwxrwt root root 2010-04-27 22:05 sqlite_stmt_journals
drwxrwx--- system cache 2009-11-13 20:35 cache
d---rwxr-x system sdcard_rw 1970-01-01 00:00 sdcard
lrwxrwxrwx root root 2010-04-27 22:05 etc -> /system/etc
drwxr-xr-x root root 2009-09-15 03:17 system
drwxr-xr-x root root 1970-01-01 00:00 sys
drwxr-x--- root root 1970-01-01 00:00 sbin
dr-xr-xr-x root root 1970-01-01 00:00 proc
-rwxr-x--- root root 10700 1970-01-01 00:00 init.rc
-rwxr-x--- root root 1677 1970-01-01 00:00 init.goldfish.rc
-rwxr-x--- root root 106696 1970-01-01 00:00 init
-rw-r--r-- root root 118 1970-01-01 00:00 default.prop
drwxrwx--x system system 2009-11-13 20:35 data
drwx------ root root 1970-01-01 00:00 root
drwxr-xr-x root root 2010-04-27 22:05 dev
# cd data/data/com.paad.todolist/databases/
cd data/data/com.paad.todolist/databases/
# ls -l
ls -l
-rw-rw---- app_28 app_28 5120 2010-04-27 22:05 todoList.db
# sqlite3 todoList.db
sqlite3 todoList.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .tables
.tables
android_metadata todoItems // here the database is open
sqlite> select * from todoItems;
select * from todoItems; // the todoItems already entered are supossed ouput in this line

This is a site that a have step by step tutorial.

The sequence of the SQLite commands was my error.

Now fine

http://www.screaming-penguin.com/node/7742