hello, I would like to use transparent encryption on sqlite.
I found sqlcipher and wxsqlite.
I downloaded sqlite3.dll from
https://github.com/utelle/wxsqlite3/releasesand simply overwrote the standard dll.
I use my sample project. Everything continues working. Nice.
And now I want to encrypt a database.
When I tried to do it using
SQLiteConnection1.ExecuteDirect('UserAdd(wxT("testuser"), wxT("testpswd"), true) ');
SQLiteConnection1.ExecuteDirect('UserLogin(wxT("sampleuser"), wxT("samplepswd")) ');
I got syntax error near "UserAdd", what a surprise!
At least the wxT function is unknown.
Does anybody tried to use Wxsqlite in Lazarus successfully and knows how to do it?
Thank you for help.