SQLite with Delphi 7

[stameni 0]

Hello *.*

 

I am a SQLite beginner. I'd like to make simple database with Delphi 7.

 

Is out there any tutorial about installing and using SQLite in D7?

 

I have tried with sqlite-dll-win-x86-3460100.zip, by unzipping it to some folder, and adding that folder to D7 using Tools / Environment Options / Library tab / Library path. However, it doesn't seem to be enough...

 

I develope using a virtual machine with 32-bit Windows XP and Delphi 7.

[corneliusdavid 213]

9 hours ago, stameni said:

SQLite in D7?

It looks like ZeosLib is still active: https://sourceforge.net/projects/zeoslib/

 

I have no experience with it but recent updates says it supports Delphi 7 through 12. 

[zed 14]

Extract sqlite3.dll into the folder where Delphi outputs your application .exe file, and use this wrapper: https://github.com/plashenkov/SQLite3-Delphi-FPC (there is a usage example: https://github.com/plashenkov/SQLite3-Delphi-FPC/blob/master/Examples/Delphi/Main.pas).

[stameni 0]

I tried the advice @zed had given, and it worked 🙂 Thank you!

Just a note: file sqlite3.dll from the github link can be replaced by a newer version from the official link.