Fresh Install + sqlite
lazarus / 16-Databases

----------------------------------------------------------------------
moodsoft · 2013-05-05 04:11

Hi all,

I've been trying to build an SQLite app with Lazarus and I seem to be
having issues. So I'm hoping someone will be able to give me step by
step instructions from a fresh install of Lazarus of how to add SQLite
so I can get to coding as soon as possible. I tried to follow the
directions here: http://sqlite4fpc.yolasite.com/update-fpc-
component.php and wounded up getting the error: "The procedure entry
point sqlite_changes could not be located in the dynamic link library
sqlite.dll" this was with using the latest sqlite.dll from
http://sqlite.org/download.html

Help is greatly appreciated!

Chris

----------------------------------------------------------------------
ludob · 2013-05-05 06:28

Looks like you are trying to use TSqliteDataset with a sqlite3 dll.
The dll you downloaded has to be used with TSqlite3Dataset  in unit
sqlite3ds. The functions exported by sqlite.ddl start with sqlite3_
instead of sqlite_.

----------------------------------------------------------------------
moodsoft · 2013-05-06 01:57

OK I was able to confirm that I do have access to the unit sqlite3ds
however I do not seem to see an icon called TSqlite3Dataset, can you
tell me what I need to do to enable that?

Chris

----------------------------------------------------------------------
ludob · 2013-05-06 06:26

You need to install the package sqlite3laz.lpk. If you installed
sqlitelaz.lpk you can better uninstall that package to avoid mistakes
later.

----------------------------------------------------------------------
moodsoft · 2013-05-07 01:15

I did this and now told that I need sqlite.dll not sqlite3.dll,
however I can't seem to find sqlite.dll for Windows anywhere.

Really wish it came fully installed in Lazarus .

----------------------------------------------------------------------
ludob · 2013-05-07 06:00

You still use the wrong units. Sqlite3DS uses sqlite3 which does an
include of sqlite3.inc. There you'll find
Code: [Select]{$IFDEF WINDOWS}
  Sqlite3Lib = 'sqlite3.dll';
{$else}

Check that all references to sqliteDS or sqlite are gone from all the
uses sections in your program. Better, start a new program, drop a
TSQLite3Dataset on a form, configure it and test that.

----------------------------------------------------------------------
Leledumbo · 2013-05-07 06:50

QuoteReally wish it came fully installed in Lazarus .Possible since
the license is very permissive (public domain), but I don't think any
of the maintainer here want to add that burden to the package. It
would be maintenance hell.

----------------------------------------------------------------------
moodsoft · 2013-05-16 03:41

In case there is an easier way, are there any databases that do not
require a server back end that Lazarus / Free Pascal supports out of
the box?

----------------------------------------------------------------------
Pascaluvr · 2013-05-16 04:13

I use SQLite3 for my own projects....   without a problem

If you use win7 ....   put the sqlite3.dll in c:windows\SYSWOW64
(works for both 32 bit and 64 bit)

----------------------------------------------------------------------
BigChimp · 2013-05-16 05:31

Quote from: moodsoft on May 16, 2013, 05:41:47 amIn case there is an
easier way, are there any databases that do not require a server back
end that Lazarus / Free Pascal supports out of the box?
tdbf, zcsv. See the wiki for those two.

I wouldn't recommend them so quickly though. Yes, installing dlls is
troublesome, but IMO a good tradeoff for the loads of features e.g.
Firebird or sqlite can bring you.
That said: to each his own

----------------------------------------------------------------------
moodsoft · 2013-05-24 03:15

I see that I have many copies of SQLite3.dll on my computer, while I
know it is a waste of disk space is there anywhere in the Lazarus tree
I can store the dll that Lazarus will see it?

----------------------------------------------------------------------
Leledumbo · 2013-05-24 06:40

QuoteI see that I have many copies of SQLite3.dll on my computer,
while I know it is a waste of disk space is there anywhere in the
Lazarus tree I can store the dll that Lazarus will see it?The top
directory, where (start)lazarus executable exists.