Page 1 of 1

Create Database

Posted: Thu 23 Aug 2012 16:42
by 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

Re: Create Database

Posted: Fri 24 Aug 2012 06:04
by TomekC
Hi.
TLiteConnection.Options.ForceCreateDatabase

Re: Create Database

Posted: Mon 27 Aug 2012 07:53
by 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.

Re: Create Database

Posted: Mon 27 Aug 2012 16:39
by 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

Re: Create Database

Posted: Wed 29 Aug 2012 07:06
by 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 .