Question

如何删除所有记录数据库。

 +(BOOL)deleteFromtbl {
        sqlite3 *database;
        BOOL retValue = YES;
        if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
            const char *sqlStatement = "Delete from tbl";
            sqlite3_stmt *compiledStatement;
            retValue = sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL);
            sqlite3_finalize(compiledStatement);
        }
        sqlite3_close(database);

        return retValue;        
    }

这些法典对我没有作用。

提前感谢。

Answer 1

qlite3 = 步骤,这一职能需要在编写声明之后进行。

以这种方式使用

+(BOOL)deleteFromtbl {
        sqlite3 *database;
        BOOL retValue = YES;
        if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
            const char *sqlStatement = "Delete from tbl";
            sqlite3_stmt *compiledStatement;
            retValue = sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL);
if(SQLITE_DONE != sqlite3_step(compiledStatement))//add this line
    {
        NSLog(@"Error while inserting data.  %s ", sqlite3_errmsg(database));
        return NO;
    }
            sqlite3_finalize(compiledStatement);
        }
        sqlite3_close(database);

        return retValue;        
    }

友情链接