On 19 mai 2011, at 11:21, irfan khan wrote: Hi,
We got a new iPad and have to test sqllite database. Could you please guide me to test. Basically I want to create database, create tables insert some records, and fetch records from iPad itself. Is there any way to create database on iPad for preinstalled sqlite. SQLite is a C library. On the iPad as on any other machine, you create an SQLite database using that library. Here is the routine in my iPad application that creates a database: - (MyClass *) initWithObject:(MyObject*) objectToManage { if ((self = (MyClass*)[super initWithObject: objectToManage])) { NSString *dirPath = objectToManage.absoluteDirPath; NSString *sourceFilePath = [dirPath stringByAppendingPathComponent: objectToManage.fileName]; NSString *basePath = [sourceFilePath stringByDeletingPathExtension]; NSString *tilePath = [basePath stringByAppendingPathExtension:@"SQL"]; NSLog(@"Opening SQLite file %@", tilePath); sqlite3 *db; int rc = sqlite3_open([tilePath cStringUsingEncoding:NSUTF8StringEncoding], &db); if (rc != SQLITE_OK) { NSLog(@"Can't open database: %s", sqlite3_errmsg(db)); sqlite3_close(db); [self release]; return nil; } self.db = db; [self createTablesIfNeeded]; sqlite3_stmt *compiledStatement = NULL; rc = sqlite3_prepare_v2(db, "select max(thoroughness) from Table;", -1, &compiledStatement, NULL); rc = sqlite3_step(compiledStatement); self.levelsOfThoroughness = sqlite3_column_int(compiledStatement, 0); NSLog(@"This file has %d levels of thoroughness", self.levelsOfThoroughness); } return self; } In there you can see: - how to open a database - how to close a database - how to execute a SQL statement - how to check for error Which should be a good start. Jean-Denis Muys _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users