ARrrgh...
The database exists but it contains nothing?! I double checked it in
my trusty firefox sqlite extension, and everything is there.
Is there some magic "touch" I need to do to get the tables properly
into the device? I have cleaned my project, restarted xcode, rebuilt,
etc.
thanks
James
On Feb 27, 2009, at 10:55 AM, Bill Bumgarner wrote:
On Feb 27, 2009, at 8:44 AM, James Cicenia wrote:
Don't use UTF8String to get a C string for a file system path, you
should use -fileSystemRepresentation.
I don't even know what that is?
It is documented-- google, Xcode's documentation window, or
developer.apple.com will quickly fulfill your curiosity:
http://developer.apple.com/iphone/library/documentation/Cocoa/Reference/Foundation/Classes/NSString_Class/Reference/NSString.html#/
/apple_ref/occ/instm/NSString/fileSystemRepresentation
(Sorry to be harsh -- but "RTFM" is something we all fail to do far
too often and I'm singly you out to remind me to do the same :)
if (sqlite3_open([path UTF8String], &database) == SQLITE_OK) {
const char *sql = "SELECT type, subtype, name, id FROM
ProduceItem ORDER BY name";
sqlite3_stmt *statement;
if (sqlite3_prepare_v2(database, sql, -1, &statement, NULL) ==
SQLITE_OK) {
You can grab more error information by doing something like:
NSLog(@"Oops %s", sqlite3_errmsg(database));
If it says that the table doesn't exist then the database isn't
being correctly installed (or correctly initialized).
b.bum
_______________________________________________
Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com