Database start... a good and working example/doc ?
Hi all,
I'm trying to work with the Titanium.Database API but still can get anything good from it…
I created a new folder under Resources and I wanna save my db file there… this is the 5lines of code that I run (according to the documentation)
http://www.pastie.org/private/yl8gmetsjgdfdpmchqdbg
but I keep getting the same error:
A SQLite database error occurred on database
'......./Library/Application Support/database/dbtest.db.sql':
Error Domain=com.plausiblelabs.pldatabase Code=1 UserInfo=0x53280a0
"The SQLite database file could not be found."
(SQLite #14: unable to open database file) (query: '<none>')
[WARN] couldn't open database. in -[TiDatabaseProxy open:] (TiDatabaseProxy.m:79)
[ERROR] Script Error = couldn't open database.
in -[TiDatabaseProxy open:] (TiDatabaseProxy.m:79) at app.js (line 83).
3 Answers
-
Accepted Answer
Is there any reason why you need to specify where the DB is located and not just let the device handle that (which it does without any issues)
check out the persistence demo application (http://github.com/kwhinnery/Persistence), it's a great place to "get started"
-
Is that file you're trying to install a SQL script or an actual database file? The latter is what you need (an actual SQLite database). Easiest way to work with a SQLite database is through a tool like this simple admin app (Firefox plug-in).
-
The Persistence app…does the job ;)
Thanks for the tip.