SQLite Problem

[stephen]

Hello,

I'm trying to select data from the database and I have the following code in place:

// Setup the database object
	sqlite3 *database;
	
	// Init the animals Array
	list = [[NSMutableArray alloc] init];
	NSLog(@"documents path: ", documentsDir);	
	NSLog(@"database path: ", databasePath);
	
	// Open the database from the users filessytem
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) 
	{
		// Setup the SQL Statement and compile it for faster access
		const char *sqlStatement = "select route_name from Route";
		sqlite3_stmt *compiledStatement;
		if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) 
		{
			// Loop through the results and add them to the feeds array
			while(sqlite3_step(compiledStatement) == SQLITE_ROW) 
			{
				// Read the data from the result row
				NSString *aName = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 1)];
				
				// Add the animal object to the animals Array
				//[list addObject:animal];				
				[list addObject:aName];				
				//[animal release];
			}
		}
		// Release the compiled statement from memory
		sqlite3_finalize(compiledStatement);		
	}
	sqlite3_close(database);

I'm getting EXC_BAD_ACCESS error at the first IF statement. Anyone any thoughts.

Also in the NSLOG documentsDir and databasePath are blank.

I have the following code in ViewDidLoad:

-(void)viewDidLoad 
{	
	// Setup some globals
	databaseName = @"xxxxxxCoreData.sqlite";
	
	// Get the path to the documents directory and append the databaseName
	NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
//	NSString *documentsDir = [documentPaths objectAtIndex:0];
	documentsDir = [documentPaths objectAtIndex:0];
	databasePath = [documentsDir stringByAppendingPathComponent:databaseName];

[F.R.E.E.]

you answered your own question, the path to the database is NULL.

[stephen]

Originally Posted by F.R.E.E.

you answered your own question, the path to the database is NULL.

Thanks FREE, yeah I kind of guess that. Any ideas why the path is null ?

[stephen]

Okay, I've updated the code slightly and I'm getting the database path now:

-(void)viewDidLoad 
{	
	NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
	NSString *documentsDir = [documentPaths objectAtIndex:0];
	databasePath = [[documentsDir stringByAppendingPathComponent:databaseName] copy];
}

But its not its doesn't go through the following IF statement:

	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)

Any thoughts ?