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

Filed under:
|

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

Related posts about iphone

Related posts about sqlite