Quick note: Please do not set 'reply-to' like that when using a discussion list. It's important if a question is posted to the list, answers to it get posted to the list. This is so that if the first answer to a question is wrong, someone else can see it and post a correction. It also allows the readers of the list to see whether someone else has answered a question, which means they don't have to bother posting the same advice themselves.
On 18 Jul 2009, at 7:46am, Jim Showalter wrote: > It's an update. Good. That's what I thought you wanted but I've seen people make that mistake before. > I don't know how to test this with the SQLite console, because it's > actually running on the Android emulator. Get your database file to the point where you're just about to do the UPDATE command then have your application close it and terminates without changing it again. Copy the database file to your development platform (your Windows/Mac/ Linux computer). Open the database file with the 'sqlite3' command (which you'll have to find yourself) in interactive mode: <http://www.sqlite.org/sqlite.html> Doing a couple of commands to make sure the schema and data got copied over correctly. Try executing the UPDATE command and see what the command-line tool spits out. If it spits out the RAISE message you wanted, the problem is with the API you're using, or how you're using it, so you need to consult someone who understands the Android API. If it doesn't, there's something wrong with your how SQLite works, or your understanding of how SQLite works, and you can post again describing what went wrong. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users