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 07-31-2010, 06:35 PM   #1 (permalink)
Registered Member
 
Join Date: Jul 2010
Posts: 5
Skyman is on a distinguished road
Default SQLite3 - Updating database in Xcode

I struggling to update my database in xcode. I know the database is there and functioning on the device and the simulator. but I want to update one of the entries based on user input. The code looks like this:

sqlite3_stmt *updateStmt = nil;

if(updateStmt == nil) {
const char *sql = "UPDATE DATABASENAME SET LEVEL_DATA = ? WHERE ROW = ?";
if(sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(database));
}

sqlite3_bind_int(updateStmt, 1, level);
sqlite3_bind_int(updateStmt, 2, rowNum);

if(SQLITE_DONE != sqlite3_step(updateStmt))
NSAssert1(0, @"Error while updating. '%s'", sqlite3_errmsg(database));

sqlite3_reset(updateStmt);




Did I do something wrong? sometimes i see a SIGABRT type error, other times it just doesn't update , crash or do anything. I'm puzzled.

Last edited by Skyman; 07-31-2010 at 06:44 PM.
Skyman is offline   Reply With Quote
Reply

Bookmarks

Tags
database, sql, sqlite3, update, xcode

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: 353
9 members and 344 guests
alexP, gordo26, headkaze, mistergreen2011, nobstudio, Objective Zero, rayjeong, revg, Sloshmonster
Most users ever online was 1,387, 04-10-2012 at 04:21 AM.
» Stats
Members: 175,655
Threads: 94,116
Posts: 402,889
Top Poster: BrianSlick (7,990)
Welcome to our newest member, pungs
Powered by vBadvanced CMPS v3.1.0

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