Wrox Programmer Forums
|
BOOK: Professional iPhone and iPad Database Application Programming
This is the forum to discuss the Wrox book Professional iPhone and iPad Database Application Programming by Patrick Alessi; ISBN: 978-0-470-63617-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional iPhone and iPad Database Application Programming 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
 
Old June 19th, 2011, 10:45 PM
Registered User
 
Join Date: Jun 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem when working with SQLite in Ch2

I keep running into a problem working with SQLite in the terminal. Sometimes when I enter a command I'll start seeing "..." like this:

sqlite> .import "countries.txt" Country
sqlite> select * from country
...> select * from Country

No matter what I do, I can't get anything else to work. I just keep getting ...> over and over. I understand from the SQLite site that this means it's a continuation and it's waiting for more info, but I don't know what to do. Can anyone help?
 
Old June 21st, 2011, 10:57 PM
Friend of Wrox
 
Join Date: Aug 2010
Posts: 298
Thanks: 1
Thanked 62 Times in 60 Posts
Default

If you post a copy of your terminal session from the creation of the database to the problem, a solution should be able to be arrived at. Based on what you have posted there is a strong hint, but it will be clearer with a full listing.

Bob
 
Old July 12th, 2011, 01:35 AM
Authorized User
 
Join Date: May 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Did you put a semi colon ; at the end of the statements?
 
Old July 13th, 2011, 02:40 PM
Registered User
 
Join Date: Jul 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default .separator \t

do not put \t in quotes
 
Old July 18th, 2011, 09:55 PM
Registered User
 
Join Date: Jun 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm sorry I've been so late in responding. I was borrowing the book from my boss, and he needed it back, so I haven't been working on it. Once I get back to it I'll see if I can work it out.

Thanks for your replies.





Similar Threads
Thread Thread Starter Forum Replies Last Post
improving SQLite write performance with PRAGMA (Zend Cert) crmpicco PHP Databases 0 May 20th, 2010 05:33 PM
CHAP 12: SQLite - sqlstddev.lua p 409 jazper BOOK Beginning Lua Programming ISBN: 978-0-470-06917-2 0 June 7th, 2009 11:30 AM





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