CODEWITHSUNDEEP
iphoneobjective-c
shajem
shajem

Reputation: 2121

Reading a list of records SQLite - Need advice

I have some data (Student info), and my app should be able to read and display these student records in a UITableView.

I need to know the following;

  1. ) Where should i store these student records ? I know that i could store them in the SQLITE query browser (in the MAC) but, when users install the app on the device how are they going to read the student records from (because the iPhone doesn't have a query browser for someone to enter the records) ?

Upvotes: 0

Views: 83

Answers (2)

Max_Rai
Max_Rai

Reputation: 68

when you will create a sqlite database, you have to store it in your application folder only just like any local image for app like Default.png or icon.png.... and when you run your app on device the sqlite database also will be loaded together with the application....sqlite database will be stored as a file with extension .sqlite onle...copy it in your app...it will just execute just fine.....when you write coding like "Select *..." or "INsert into..." or "delete from...." remember to give the correct name of the sqlite file copied in your app...

Upvotes: 2

iDhaval
iDhaval

Reputation: 7844

After creating Database in SQLITE save that Database, which gives you file with extension .sqlite then drag and drop that .sqlite file in to Resources folder of you application program in XCODE and then install in you iPhone It will work. and you can use Sqlite using iPhoen

Upvotes: 1

Related Questions