| Navigation: SQL Drivers > SQLite Accelerator >SQLite Properties |    |
PROP:CreateDB
PROP:CreateDB is a command property. This command property tells the SQL Accelerator to create the SQLite Database file that is specified in the OWNER attribute of the file.
If the database file already exists, this command does nothing. The existing database file will not be destroyed.
You can also create a database by issuing a CREATE statement for any table in that database. If the database does not exist, it will be created and the table will also be created in the database.
You would use this property if you are using SQL statements to create the database rather than the Clarion CREATE statement.
Example:
sqlTable FILE,DRIVER('SQLite'),OWNER('MyDatabase.sqlite')
RECORD
END
END
CODE
sqlTable{PROP:CreateDB} ! Will create the file MyDatabase.sqlite
IF ERRORCODE() ! test to see if the create worked