Hi I'm sqlite3 in my app. When app run data are update in (LIb/Application Suuport/Iphone simu/IOS4.2/App/Doc) ther create new database and saved there pls give me solution pls pls. code is - (void)viewDidLoad { NSString *docsDir; NSArray *dirPaths; // Get the documents directory dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); docsDir = [dirPaths objectAtIndex:0]; // Build the path to the database file databasePath = [[NSString alloc] initWithString: [docsDir stringByAppendingPathComponent:@nameadd.sqlite]]; NSFileManager *filemgr = [NSFileManager defaultManager]; if ([filemgr fileExistsAtPath: databasePath ] == NO) { const char *dbpath = [databasePath UTF8String]; if (sqlite3_open(dbpath, &contactDB) == SQLITE_OK) { char *errMsg; const char *sql_stmt = CREATE TABLE IF NOT EXISTS add1 ( fname TEXT, addr TEXT, phon VARCHAR); if (sqlite3_exec(contactDB, sql_stmt, NULL, NULL, &errMsg) != SQLITE_OK) { status.text = @Failed to create table; } sqlite3_close(contactDB); } else { status.text = @Failed to open/create database; } } [filemgr release]; [super viewDidLoad]; }

What is your question.

how to setpath for database file .bsu when i run app it create new database and store value in new database

Have no idea. If it's not a buzztouch related question I'm not the right person to ask. Maybe do a Google Search for SQL Lite iOS and see what you come up with?