how to connect with sqlite in iphone?

Question

Hi... I am developing an application in iphone and am new to iphone. Kindly let me know the code for open/close/update/delete database record in iphone using sqlite?

Regards, Vijaya

Answer 1

Read the sqlite documentation on their website. They have API references and tutorials. All you need to get going in XCode is to add the libsqlite3.dylib to the referenced frameworks.

Answer 2

Please, go trough the following link u will get some idea about handling the database. http://www.switchonthecode.com/tutorials/using-sqlite-on-the-iphone

http://icodeblog.com/2008/08/19/iphone-programming-tutorial-creating-a-todo-list-using-sqlite-part-1/

http://www.iphonesdkarticles.com/2009/02/sqlite-tutorial-saving-images-in.html