iOS 7 Tutorial 19 - SQLite Databases part 2

preview_player
Показать описание
This two part tutorial covers how to implement an application that uses SQLite Databases to store information about users, and how to edit that information through queries.

Here is the final github repository.
Рекомендации по теме
Комментарии
Автор

On the save button I am getting I narrowed down the error I was getting to a SQLITE_MISUSE error. Any ideas as to why I may be getting this?

drewgelinas
Автор

Very useful!
But where is "myUsers.db" created?
Thank you so much!

ngathai
Автор

very useful, everything went smoothly,
but what's the path for "myUsers.db" so I can put my database in this path?
Thanks!

danaalmadi
Автор

So do you have to always write all these basic commands when saving data using sqlite? 
and also, what does this text mean, "INSERT INTO users (name, address, phone) VALUES .... ", And why is it in upper case and lower case mixed?
Thank you for the tutorial!

deepak
Автор

great tutorial.. helped me a lot!! thaX

Clab
Автор

Your code could not achieve the find method in it has to delete the sqlite3_finalize(statement) before the sentence sqlite3_close(_DB);

weixiao
Автор

i able to run in simulator but when i tested in device it pop up alert message with failed to open/create the table. may i which part i had done wrongly?

JolinTeoh
Автор

myusers.db not present in this project, i also checked on github tutorial posted by u, please give clarification on that

ramakrishnamedagam
Автор

Hey great tutorial on sqlite3!

I have an error which I can't fix. 
when I click on delete, it displays the error, and I can see that the data hasn't been deleted.
My guess is there's something wrong with: sqlite3_open(dbpath, &_DB) == SQLITE_OK
but I can't know what exactly is causing this, any ideas?

MrFerFrassia
Автор

You can download the sample on github? tks.

mvalbuquerque