Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2
This is the forum to discuss the Wrox book Professional Android Application Development by Reto Meier; ISBN: 9780470344712
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 27th, 2010, 05:57 PM
Registered User
 
Join Date: Apr 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Red face Chapter 6 Todolist & SQLITE3

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
  #2 (permalink)  
Old April 28th, 2010, 12:57 PM
Registered User
 
Join Date: Apr 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Got the solution

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
chapter 2 todolist kdpohl1 BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 5 July 16th, 2010 03:59 AM
Tiny C Compiler and Lua-sqlite3 lyzby BOOK Beginning Lua Programming ISBN: 978-0-470-06917-2 0 April 8th, 2009 11:48 PM
Chapter 4 - customizing ToDoList - ruled lines not working correctly gregking BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 1 April 3rd, 2009 09:44 AM
Chap 2 ToDoList - Stopped Unexpectedly sierawsk BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 1 March 4th, 2009 01:14 PM
SQlite3 on ruby on railsb amadanes RoR Ruby on Rails 0 February 21st, 2009 09:43 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.