Advertise Mobile SDKs Books Events Forum News Social Networking Support Us
Follow @iphonedevsdk on Twitter

Interface 2, Advanced iOS
Mockup & Code Gen
($9.99)

Make your own iPhone apps
and run them live!
(free)

Pic Frame Dynamo: Photo Editing
($0.99)

Abiliator
($1.99)

Want your application or service advertised on iPhone Dev SDK?

Go Back   iPhone Dev SDK Forum > iPhone SDK Development Forums > iPhone SDK Development

Reply
 
LinkBack Thread Tools Display Modes
Old 10-26-2010, 08:07 AM   #1 (permalink)
Registered Member
 
Join Date: Jul 2010
Posts: 141
jenesapp is on a distinguished road
Default when insert data in to sqlite out of memory

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) addProjectProject*) 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 ?

Last edited by jenesapp; 10-27-2010 at 01:17 AM.
jenesapp is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



» Advertisements
» Online Users: 329
14 members and 315 guests
7twenty7, chiataytuday, condor304, Creativ, Domele, dreamdash3, laureix68, LEARN2MAKE, mistergreen2011, mottdog, palme2elie, Paul Slocum, schmallegory
Most users ever online was 1,387, 04-10-2012 at 04:21 AM.
» Stats
Members: 175,660
Threads: 94,118
Posts: 402,895
Top Poster: BrianSlick (7,990)
Welcome to our newest member, laureix68
Powered by vBadvanced CMPS v3.1.0

All times are GMT -5. The time now is 01:20 AM.
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0