PDA

View Full Version : SQLite linking/retrieving from a database help




mekopolis
Sep 1, 2008, 07:07 PM
Im sorry I accidently posted this in the mac programming forum, but it has to do with programming for the iphone


I'm new to Programming on a Mac platform and on the OS X / iphone SDK
so forgive me if this isn't blatantly obvious
i am designing an app that connects to a database to display its contents
after researching it a bit, and even playing around in the CoreData interface, I read this from Apple's Developer Page:


"How do I bundle an SQLite database with my application?

Add the existing database file to your Xcode project as you would any other resource file by dragging it to the "Resources" group in the project's Files view. When prompted, make sure you add it to the appropriate Target (if your project has more than one). The file will be copied into the application bundle when you build your project.

This is all you need to do if your database is meant to be read-only."

So I designed a Database in SQLite, and imported it into the Project

How do I link it, and retrieve data/ display it on either a table view controller or even a label.

thanks



beachdog
Sep 1, 2008, 09:30 PM
Check out the SQLiteBooks sample, it should get you started. Also www.sqlite.org

ejaa
Mar 9, 2010, 01:52 AM
please.
I am new in xcode programming.

Now, my friends and i were trying to update some of the database on xcode.
We're tried using sqlite manager adds on firefox, but it failed.
We are able to change the database in the .sqlite file, but when we are trying to run on the code, it still remains the same.


anyone??

boyplunder
Mar 9, 2010, 11:19 AM
ejaa, the problem you may have found is that most examples show sqlite being used for a database where the user updates it in the app. If you just want to use the data 'as is' you have to remember that the database is likely being written to the app's folder on the iPhone or iPod. This is because the database can't be updated in the app bundle, so it has to be saved out to be updated.

Have a look at this tutorial. It shows the typical use for a database where the user enters new details.
iphonesdkarticles.com (http://www.iphonesdkarticles.com/2008/11/sqlite-tutorial-updating-data.html)

Look out for the NSFilemanager code, which does the work. All you have to do is modify this example to retain the database and load it every time the app starts up.

That said, the latest thing to do is to use Coredata, but I find that it isn't always the best way to go with all apps and all database uses.

ADDED: I use the SQL plugin with FireFox and it works very well. My point above is probably the reason it seems to have failed.

ejaa
Mar 10, 2010, 09:08 PM
thanks alot boyplunder.


i will try my best.
:o

later if i had problems, i'll refer on macrumors.