Thanks for your advice. I'm happily building my database through the terminal window as you suggested. The program tells me if I make a mistake and SELECT is working fine so far. So much for third party software.
Jimmy Verner www.vernerlegal.com On Sep 15, 2009, at 12:06 PM, Simon Slavin wrote: > > On 15 Sep 2009, at 3:41pm, Jimmy Verner wrote: > >> Here's what happens: So far as I can tell, my new databases are >> built >> just like the old one, but when I try to import them with SQLite >> Database Browser ( see sqlitebrowser.sourceforge.net ) I am told >> "Error importing data at line 7345345." > > Forget third-party tools. There's no way we can possibly know every > bug in every third-party tool. Use the ones included with SQLite. > > There's a command-line tool on your Mac called 'sqlite3'. It can read > databases, it can read SQL commands and use them to build a database. > It can turn the database into whatever SQL commands are needed to > reproduce it. You can use it to execute SQLite commands line-by-line > including ones that check the database for corruption. To get more > information use > > man sqlite3 > > Copy your database onto your Mac and use sqlite3 on it. Try some > SELECT commands. If sqlite3 produces an unexpected error, tell us > what it is and we'll look into it. Don't worry: some of us understand > iPhone and Mac here and people can help. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
