Saturday, October 15, 2011

Delete query for sqlite3 - iPhone

// this method has executeTableQuery in this Link

    1.  Delete a Table using sqlite 

    BOOL deleteTable = [self executeTableQuery:@"DELETE FROM \"main\".\"speakers\""];


    2. Delete a row of Table

NSString *sqldelete = [[NSString alloc] initWithFormat:@"DELETE FROM cache WHERE id = %d ",cacheId];

BOOL deleteTable = [self executeTableQuery:sqldelete];