Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:19 PM.


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