[ Closed ] SQLite Lazarus

Hi Gilles,

SqlitePass doesn't use any of the files included in /usr/share/fpcsrc/packages/base/sqlite/ even if the sqlite3.pp file and SqlitePassApi-v3.pas share the main goal : to load the external sqlite library (sqlite.dll or sqlite.so) and import the functions in order to use the db engine.

In fact, I started to write this library because I needed to manipulate data from sqlite under Delphi 4 and Lazarus. As you can guess, Delphi doesn't include files like the ones found in /usr/share/fpcsrc/packages/base/sqlite/...

So I had to have my own specific files to work with Delphi.

Another difference (a huge one) is that TSqlitePassDataset is designed to work with data_aware controls and inherits from TDataset. Of course you can use it alone as a classic table or query.

I'm always interested in feedback about problems or bugs. If you use the components on linux (your files path seems to be a Linux/Unix one), let me know how the library works. I can't test it under Linux.

Of course, your feedback will be welcome even if you use win32... 

Thanks.

Luc

When I said it worked OK under Linux and Lazarus, I forgot that I was not using the design component on the form, just creating everything in the program.
There is a problem (at least under both Ubuntu 7.10 and 8.04 and Lazarus 0.9.24 and 0.9.26) where dropping a SQLitePassDatabase on a form will result in a corrupted .lfm file. Specifically, the Options.Synchronous and Options.TemporaryStorage fields have bad characters written to them. Possibly some of the bytes written look like they could be 32bit integers (looking at the .lfm file with a hex editor). Also just tried Lazarus 0.9.26 under windows and those option values also get corrupted.