hi every one
when i am inserting data in to data base i am getting this error
if(sqlite3_prepare_v2(database, sql, -1, &statement, NULL) != SQLITE_OK)
Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Error while creating add statement. 'out of memory''
this is my sqlite
create table project(pk integer primary key,name varchar(50),title varchar(50), startdate varchar(10), finishdate varchar(10));
this is my code
-(NSInteger) addProject

Project*) project
{
const char *sql = "insert into project(name,title,startdate,finishdate) values(?,?,?,?)";
sqlite3_stmt *statement;
int projectid = 0;
if(sqlite3_prepare_v2(database, sql, -1, &statement, NULL) != SQLITE_OK)
{
NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(database));
}
sqlite3_bind_text(statement, 1, [project.name UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(statement, 2, [project.title UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(statement, 3, [project.startDate UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(statement, 4, [project.finishDate UTF8String], -1, SQLITE_TRANSIENT);
if(SQLITE_DONE == sqlite3_step(statement))
{
projectid = sqlite3_last_insert_rowid(database);
}
sqlite3_finalize(statement);
return projectid;
}
any budy pls help me ?