Zeoslib Portal

Update:
Wxsqlite is working - latest update (2.1.3 - 16/08/2011).
It encrypts even when main database is :memory:
http://sourceforge.net/projects/wxcode/ ... wxSQLite3/

The site mentioned in the tutorial http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/1.0.66.0/SQLite-1.0.66.0-binaries.zip/download This site has a few different versions of the DLL. Only one of them works with Zeos. The correct one is 904,704 bytes long. See the code...

I am using System.Data.SQLite DLL. It encrypts Ok as long as the main Database is a file. The only trouble is when the main database is :memory:, any attached database will be silently created without any encryption - and it does not spitout any error messages. The workaround I am using is to create...

Seawolf, Thanks for the help. That removed the irritating error that pops up when ever I run the code. However, Zeos still creates the attached database un-encrypted when main database is :memory: con.Database:= ':memory:'; Con.Connect; Con.ExecuteDirect('ATTACH DATABASE "File.db3" AS Save...

Encryption does not work for an attached database when the main database is of type :memory: Encryption on attached database works when the main database is file based - even if one of the attached databases is memory resident. I am using System.Data.SQLite DLL. I was not able to make wxSQLite3 work...

Works Perfectly.
Thank You.

PS: Where can I find the 'Proper' documentation for Zeos?

Zeos - while being a great piece of FOS software, the big minus point for me is the documentation. (Or am I missing something?)

A few more simple samples will be in place. Will the developers take note?

Hi,
Does the ZQuery component has a FieldbyNumber property (similar to FieldbyName)?
I found one as Fields.FieldbyNumber, but it does not work as I expected.