Opening a SQLite database in Lazarus.
lazarus / 16-Databases

----------------------------------------------------------------------
BertH · 2010-07-31 16:04

While "rebuilding" a simple program using a DBase file into one using
a SqLite file I could not find how to open the file. If I enter the
file path in the filepath of the properties of the Object Inspector
the data are shown in the grid. But using the

procedure TForm1.AOpenExecute(Sender: TObject);
begin
   With ODDBA do
   if Execute then
      Openfile(Filename);
end;            
 
as used in the dBase program, I get error>> unit1.pas(88,15) Error:
Identifier not found "Openfile"

I looked through this Forum and the SQL documentation but could not
find the correct termonology for SQLite.
Would appreciate your help.


Bert

----------------------------------------------------------------------
BertH · 2010-07-31 16:11

Sorry, correction on previous question.
In dBase the term is OpenTable(...). That also gave the error in
SQLite. OpenFile was one of my estimated guesses but did not work
either.

----------------------------------------------------------------------
JD · 2010-07-31 16:38

Use Zeos Components; they work flawlessly

http://wiki.lazarus.freepascal.org/Zeos_tutorial#Make_your_first_Zeos_
application

----------------------------------------------------------------------
BertH · 2010-07-31 20:51

Thanks for the suggestion. However I just started to understand a
little of Lazarus with a very limited experience of Delphi and Access.
I am experimenting with Lazarus and SqLite to see if that could
replace the things I did with Access. I started with dBase because I
had some experience with Visual dBase a long time ago.
I looked into the Zeos link you gave but I don't see myself following
those instructions and end up with a working system let alone that I
have to learn another new dialect called Zeos. I assume there must be
a simple way to open a SQlite database from with an application. My
problem is to find that way. The available docs and forum discussions
did not help sofar.

Bert

----------------------------------------------------------------------
JD · 2010-07-31 23:53

Quote from: BertH on July 31, 2010, 10:51:42 pmI looked into the Zeos
link you gave but I don't see myself following those instructions and
end up with a working system let alone that I have to learn another
new dialect called Zeos. I assume there must be a simple way to open a
SQlite database from with an application. My problem is to find that
way. The available docs and forum discussions did not help sofar.

An alternative is SQLite Database Objects for Lazarus
http://source.online.free.fr/

The demos & examples should tell you what you need to know.