How Create a SQLite DataBase Connection on iOS

[kaiserilich]

hi,

i want to know how create a DB Connection on iOS app?

i stay Creating a App and need use a SQLite database, but i don'tm know how create the connection to create the database and tables..

i use: UniDAC, DelphiXe2 Up 4

please somebody can help me

thanks and sorry for my bad english

[ZEuS]

When using UniDAC with the SQLite provider, you can create a new database in one of the following ways:
- in UniDAC version 4.2.7 and lower you just have to set the UniConnection.Database property to a new database name and then set the UniConnection.Connected property to True. In this case, a new database will be created automatically when establishing a connection;
- to do this in UniDAC version since 4.3.8, you also have to set the ForceCreateDatabase option in UniConnection.SpecificOptions to True.
Then you can create new tables in the database using the UniConnection.ExecSQL method.
You can learn more about the properties and methods listed above in the UniDAC documentation.

[kaiserilich]

Thanks so much.

[ZEuS]

We are glad that we could help you with this question.
If you have any other questions, please do not hesitate to contact us.