¡@
2014/10/15 ¤U¤È 10:14:21
iphone Programming Glossary: sql2How to insert multiple row of data to sqlite database by iphone programming http://stackoverflow.com/questions/2200828/how-to-insert-multiple-row-of-data-to-sqlite-database-by-iphone-programming getNewDBConnection sqlite3_stmt statement nil sqlite3_stmt statement1 nil if insert_MyObj_statement nil const char sql2 DELETE FROM user sqlite3_prepare_v2 db sql2 1 statement1 NULL sqlite3_step statement1 const char sql1 INSERT INTO user id.. nil sqlite3_stmt statement1 nil if insert_MyObj_statement nil const char sql2 DELETE FROM user sqlite3_prepare_v2 db sql2 1 statement1 NULL sqlite3_step statement1 const char sql1 INSERT INTO user id name VALUES '0' 'ash' '3' 'karna' '2' 'kumar'..
Inserting NSData into SQLite on the iPhone http://stackoverflow.com/questions/3319791/inserting-nsdata-into-sqlite-on-the-iphone database if sqlite3_open databasePath UTF8String database SQLITE_OK char sql1 INSERT INTO table VALUES ' const char sql2 Identifier cStringUsingEncoding NSString defaultCStringEncoding char sql3 ' ' const char sql4 Name cStringUsingEncoding.. NSString defaultCStringEncoding char sql5 ' char sqlStatement 255 strcpy sqlStatement sql1 strcat sqlStatement sql2 strcat sqlStatement sql3 strcat sqlStatement sql4 strcat sqlStatement sql5 sqlite3_stmt compiledStatement if sqlite3_prepare_v2..
Problem with inserting data into a table http://stackoverflow.com/questions/4890315/problem-with-inserting-data-into-a-table objective c share improve this question try executing commit so setting the db to autocommit COMMIT const char sql2 COMMIT TRANSACTION sqlite3_stmt commit_statement if sqlite3_prepare_v2 database sql2 1 commit_statement NULL SQLITE_OK NSAssert1.. to autocommit COMMIT const char sql2 COMMIT TRANSACTION sqlite3_stmt commit_statement if sqlite3_prepare_v2 database sql2 1 commit_statement NULL SQLITE_OK NSAssert1 0 @ Error Message ' s'. sqlite3_errmsg database success sqlite3_step commit_statement..
|