|Sep 1, 2008, 07:07 PM||#1|
SQLite linking/retrieving from a database help
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.
|Mar 9, 2010, 01:52 AM||#3|
how i can updating my database on sqlite3?
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.
|Mar 9, 2010, 11:19 AM||#4|
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.
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.
aboutDesign: A glossary of graphic design and print terms and technology
ProofReader: A visual guide to markup and copy correction.
Last edited by boyplunder; Mar 9, 2010 at 11:23 AM. Reason: Additional text
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|How do I batch rename filenames linked in Aperture||infobleep||Digital Photography||3||Jul 30, 2011 01:37 PM|
|Reading Date from database in Ipad||ashwinr87||iPhone/iPad Programming||0||Apr 25, 2011 11:11 AM|
|Error while updating. 'attempt to write a readonly database||manoj||Mac Programming||0||Mar 17, 2011 11:18 AM|
|Linking an iPhone app's database to a website's database||cloud||Web Design and Development||5||Sep 17, 2009 11:27 PM|
|SQLite linking/retrieving from a database help||mekopolis||Mac Programming||0||Aug 31, 2008 08:59 PM|
All times are GMT -5. The time now is 02:51 AM.