Sqlite insertion problem
- by Devi
Hi, I had sqlite database for my application I am able to retrieve values from my sqlite table and inserting values with no sql error but unable to find in sqlite table....please do needful help for this problem. I just stucked up at this point plz help me here is my code
NSMutableString *registrationquery=[NSMutableString stringWithFormat:@"insert into tbl_kicks values ('%@','%@','%@')",[totalkicks text],[sessionstart text],[sessionstart text],@"0"];
//NSString *sqlNSString = [NSString stringWithFormat:@"INSERT INTO 'tbl_kicks' VALUES('%d','%@','%@');",
// 4,sessionstart.text, appDelegate.note];
const char *sqlString = [registrationquery UTF8String];
char *sqlError;
sqlite3_exec( appDelegate.database, sqlString, NULL, NULL, &sqlError );
