Search found 5 matches

by Alexandr1567
24.09.2014, 21:59
Forum: SQLite
Topic: Create new DB in run-time
Replies: 4
Views: 3111

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...
by Alexandr1567
15.09.2014, 22:50
Forum: SQLite
Topic: Using Encryption with SQLite and ZeosLib
Replies: 1
Views: 2451

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).
by Alexandr1567
15.09.2014, 22:48
Forum: SQLite
Topic: Create new DB in run-time
Replies: 4
Views: 3111

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.
by Alexandr1567
14.09.2014, 09:47
Forum: SQLite
Topic: Create new DB in run-time
Replies: 4
Views: 3111

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;...
by Alexandr1567
02.06.2014, 19:31
Forum: ZeosLib 7.2 Forum
Topic: [Delphi XE6] Querys, Sequince doesn't work
Replies: 1
Views: 1183

[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...