Hi. I am trying to take a row of my sqldatabase where the data name=X.
SO i have this...
Code:
NSString * name=[NSString stringwithformat:@"Rick"];
const char *sqlStatement = "select * from user where name=?";
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
sqlite3_bind_text(compiledStatement, 1, [name UTF8String],-1,SQLITE_TRANSIENT);
while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
Anyone knows why it is doesnt working?¿???¿?