Go Back   MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 13, 2009, 10:30 AM   #1
danmwall
macrumors newbie
 
Join Date: Apr 2009
SQLite3 Database Not Refreshing

I have an sqlite3 database in my iPhone app. This is my first iPhone app and my first time using the iPhone SDK. I have edited the database outside of the program using the terminal sqlite3 commands. I can see the changes in the terminal, but my program isn't picking them up. It is still returning the old values. Is there something I need to do to flush the cache or something so it picks up the changes?
danmwall is offline   0 Reply With Quote
Old Apr 14, 2009, 11:39 AM   #2
ghayenga
macrumors regular
 
Join Date: Jun 2008
Quote:
Originally Posted by danmwall View Post
Any ideas??
You give a paucity of information. Is this in the simulator? on the iPhone? Did you delete the old copy of the app from whatever it was? Did you do a clean all targets before you recompiled?
ghayenga is offline   0 Reply With Quote
Old Apr 14, 2009, 03:25 PM   #3
jpyc7
macrumors 6502
 
Join Date: Mar 2009
Location: Denver, CO
commit?

I've never used SQLite, but other SQL databases usually require one to "commit" the changes. That is an SQL command to save your changes.
jpyc7 is offline   0 Reply With Quote
Old Apr 15, 2009, 03:30 PM   #4
danmwall
Thread Starter
macrumors newbie
 
Join Date: Apr 2009
I figured it out. I had the database stored in my project folder and that's where I was updating it. The program, however, was looking for it in the documentsDirectory. It copied it there automatically at one point, but it wasn't refreshing it most likely because of my lack of experience! So... I updated it manually and all is well!

Thanks!
danmwall is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
GW2 Database- iPhone and iPad database for Guild Wars 2 skoroapps iPad Apps 19 Jul 20, 2013 06:59 AM
GW2 Database - iPhone and iPad database for Guild Wars 2 skoroapps iPhone and iPod touch Apps 14 Jul 20, 2013 06:58 AM
SQLite3 and UITableView jweinraub iPhone/iPad Programming 4 Jul 13, 2013 11:35 AM
A program to open sqlite3 .db files? whitedragon101 iPhone/iPad Programming 9 Mar 23, 2013 10:59 PM
Sqlite3 database Standards and properties : From .CSV or .XLS to .sqlite in Xcode 4.3 EliasRahme iPhone/iPad Programming 0 Jul 21, 2012 02:53 AM

Forum Jump

All times are GMT -5. The time now is 02:53 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC