Quick Sqlite Question

[lifeCoder45]

Hey guys, I have a quick question. I'm trying to build an sql query using an int, so I'm doing string w/ format, but apparently sqlite3_prepare_v2 wants a const char* as it's query string, not an NSString. How can I get around this?

NSUInteger row = [indexPath row];
NSString *sqlStatement = [[NSString alloc] initWithFormat:@"UPDATE `configuration` SET `currency`='%d' WHERE `id`='1'",row];
		
sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL);

My error is: "warning: passing argument 2 of 'sqlite3_prepare_v2' from incompatible pointer type"

Thanks,

Josh.

[lifeCoder45]

Never mind, I was going about it the wrong way.

Here is my new code, if anyone is interested:

if(sqlite3_open([self.databasePath UTF8String], &database) == SQLITE_OK) {
		
		static sqlite3_stmt *updateStmt = nil;
		
		if(updateStmt == nil) {
			
			const char *sql = "update configuration Set currency = ? where id=1";
			sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL);
			
		}
		
		sqlite3_bind_int(updateStmt, 1, row);
		
		sqlite3_step(updateStmt);
		
		sqlite3_reset(updateStmt);
		
	}//end if

[gunther]

check..

(sqlite3_prepare_v2(database, sql, -1, &deleteStmt, NULL) != SQLITE_OK)

or

sqlite3_bind_text(stmt, 1, [namefav UTF8String], -1, SQLITE_TRANSIENT);