NSString *databasePath = [[NSString alloc] initWithString: [docsDir stringByAppendingPathComponent: @"miAPPDB.sql"]];

NSFileManager *filemgr = [NSFileManager defaultManager];


if ([filemgr fileExistsAtPath: databasePath ] == YES)
{
const char *dbpath = [databasePath UTF8String];

if (sqlite3_open(dbpath, &contactDB) == SQLITE_OK)
{
NSLog(@"Successfully Connected");
NSString *updateSQL = [NSString stringWithFormat: @"UPDATE UserPreference SET Effect = 100 WHERE serialno = 1"];
const char *update_stmt = [updateSQL UTF8String];
sqlite3_prepare_v2(contactDB, update_stmt, -1, &update_statement, NULL);

sqlite3_finalize(update_statement);

sqlite3_close(contactDB);

}