![]() This code can be used to send the above SQL to SQLite: SQL commands such as CREATE TABLE are sent to SQLite using the ExecuteSQL method of the SQLiteDatabase class. The following SQL command creates the Team table in the SQLite database:ĬREATE TABLE Team (ID INTEGER, Name TEXT, Coach TEXT, City TEXT, PRIMARY KEY(ID)) The app location is often read-only (especially for non-admin users) which will prevent you from being able to save any changes to the database.Īs covered in Database Concepts, tables are used to store data in the database. If the database already exists, then CreateDatabaseFile will connect to the existing database instead.ĭo not place your database file alongside the desktop app itself. DB As SQLiteDatabase is a property on the App object ![]() For web projects you usually want it to be on the Session object.ĭbFile = SpecialFolder. For desktop and iOS projects you'll likely want this property to be on the App object or in a module. When working with a SQLite database you will want to have a database property available so you can easily use it throughout your app. You can learn more about SQLite by visiting their web site: The Database Property You can put data of any type in any column, regardless of the type the column has defined. Unlike most databases, SQLite does not have a strictly typed columns. It works great for desktop, web and iOS apps. ![]() SQLite is an open-source, public-domain embedded database that is used by all types of software. You access it using the SQLiteDatabase class. 5 Retrieving, Adding, Changing and Deleting Data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |