Sqlite insertion problem
Posted
by
Devi
on Stack Overflow
See other posts from Stack Overflow
or by Devi
Published on 2011-02-28T05:58:49Z
Indexed on
2011/02/28
7:24 UTC
Read the original article
Hit count: 142
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 );
© Stack Overflow or respective owner