Search found 5 matches
- 24.09.2014, 21:59
- Forum: SQLite
- Topic: Create new DB in run-time
- Replies: 4
- Views: 3165
Re: Create new DB in run-time
Thanks.. Not sure It's a bug or not: 1. Set to TZConnection.Database path to non-exists DB file. 2. Connect and DirectExec PRAGMAs => DB file creates with defined PRAGMAs. 3. Try to create tables.. 4. SQL Error: SQL logic error or missing database. So bad... But... 1. Set to TZConnection.Database pa...
- 15.09.2014, 22:50
- Forum: SQLite
- Topic: Using Encryption with SQLite and ZeosLib
- Replies: 1
- Views: 2502
Re: Using Encryption with SQLite and ZeosLib
Not full with ZEOS. See SQLCipher project: https://www.zetetic.net/sqlcipher/
With it sources need rebuild sqlite sources I write some additionals API for connection(May be), not sure).
With it sources need rebuild sqlite sources I write some additionals API for connection(May be), not sure).
- 15.09.2014, 22:48
- Forum: SQLite
- Topic: Create new DB in run-time
- Replies: 4
- Views: 3165
Re: Create new DB in run-time
Yes!1 Something works!
I disable AutoCommit propery of connection.
Can I switch this property when connection eastablished?
e.g,:
Set DB
Open DB
Switch AutoCommit off
Set Pragmas
Shitch AutoCommin On
Cunnectly I've recoonect DB after AutoCommit is switched.
I disable AutoCommit propery of connection.
Can I switch this property when connection eastablished?
e.g,:
Set DB
Open DB
Switch AutoCommit off
Set Pragmas
Shitch AutoCommin On
Cunnectly I've recoonect DB after AutoCommit is switched.
- 14.09.2014, 09:47
- Forum: SQLite
- Topic: Create new DB in run-time
- Replies: 4
- Views: 3165
Create new DB in run-time
Hello! Can anybody say how to create database in run-time using ZEOS? I'm need: 1. Create database 2. Set PRAGMAs 3. Create tables If not exists DB file, then it will be created. I know about that. But PRAGMAs don't set. I trying do it using code: var ss: TStringList; begin ss := TStringList.Create;...
- 02.06.2014, 19:31
- Forum: ZeosLib 7.2 Forum
- Topic: [Delphi XE6] Querys, Sequince doesn't work
- Replies: 1
- Views: 1195
[Delphi XE6] Querys, Sequince doesn't work
Greetings to all! I have Delphi XE6 with installed ZEOS 7.2(Alpha) from svn. I can't use TZquery(TZReadOnlyQuery) in run-time, and even in design-time! Error message: "SQL error: SQL logic error or missing database: ." Error stack: [167381F9]{ZComponent200.bpl} ZDbcSqLiteUtils.CheckSQLiteE...