Create Database

[jbmiller]

Ok, I'm stumped. In other posts, it looks like if a SQLite database file doesn't exist, it will be created when the connection component connects. All I get is an error that says the db file doesn't exist.

So, what's the key to creating a database?

Thanks,
Bill

[TomekC]

Hi.
TLiteConnection.Options.ForceCreateDatabase

[ZEuS]

Yes, in order to create a new database when establishing a connection, you have to set the TLiteConnection.Options.ForceCreateDatabase property to True.
We have added this property to provide an ability to avoid common mistakes when the path to the database is entered incorrectly, so that a new database is created, and the application starts to work improperly.

[jbmiller]

That looks like it did it.

Is there a way to view documentation other than through Delphi Help? IBDac was installed along with SQLite. It appears that I'm only getting the IBDac help because the force create option is not listed in the help.

Thanks,
Bill

[ZEuS]

You can open LiteDAC documentation using the "LiteDAC -> LiteDAC Help" menu in Delphi IDE.
If you are using a version of Delphi since Delphi 2005, please make sure that either "No Filter" or "Devart Documentation" filter is set in the help window.
Also, you can download a separate LiteDAC documentation in pdf and chm formats from our web-site: http://www.devart.com/litedac/download.html .