Recent

Author Topic: [REQ] Example Lazarus/SQLite Application  (Read 1979 times)

Picard

  • New Member
  • *
  • Posts: 21
Re: [REQ] Example Lazarus/SQLite Application
« Reply #15 on: July 01, 2019, 09:22:43 am »
Thanks bee.  The translated page looks helpful.  I'll study it too.

You might want to read this tutorial on how to connect to an sqlite database using sqlDB classes in Free Pascal. It's originally written in Indonesian, but Google Translate could help you read it in any language of your choice.

Example, here's in english. The original text is here.

HTH.

lucamar

  • Hero Member
  • *****
  • Posts: 2084
Re: [REQ] Example Lazarus/SQLite Application
« Reply #16 on: July 01, 2019, 01:46:25 pm »
Thanks lucamar.  I remember now that the "wow64" folder is the correct place.  I saw somewhere that the dll also needs to be in one of the project folders.  Is that correct?

Not "also", but "instead" (if you want). In the absence of an explicit path, the DLL is searched for (IIRC) first in the same directory the executable is in, then in the corresponding system folders.

And maybe, if not yet foud, in the directories pointed to in "PATH"? Though I'm not sure of this.

I'm sure Microsoft has this info somewhere in their docs, but bottom-line recommendation is: put extra DLLs with your executable and use system ones from the system folders.

That's it, basically :)
Turbo Pascal 3 CP/M - Amstrad PCW 8256 (512 KB !!!) :P
Lazarus 2.0.2/2.0.4  - FPC 3.0.4 on:
(K|L)Ubuntu 12..16, Windows XP SP3, various DOSes.

Pascal

  • Hero Member
  • *****
  • Posts: 832
Re: [REQ] Example Lazarus/SQLite Application
« Reply #17 on: July 03, 2019, 03:17:21 pm »
Thanks lucamar.  I remember now that the "wow64" folder is the correct place.  I saw somewhere that the dll also needs to be in one of the project folders.  Is that correct?
No. Only if the dll is not available in the default system directory it has to be in the directory of the executable or you use SetDllDirectory for you app.
laz trunk - fpc trunk 32bit - Windows 10 Pro x64 (1803)