Is there an other component for Sqlite Dataset ?
lazarus / 16-Databases

----------------------------------------------------------------------
djalil · 2010-02-13 21:02

I tried ZEOSDBO-6.6.6 with sqlite  When i compile it for wince i got
error !!!!!

I heard about  sqlite4fpc  but there is no download link in the mirror
:

http://sqlite4fpc.yolasite.com/download.php

Is there an other component for Sqlite Dataset ......!!!!!!   ?

thanks..

----------------------------------------------------------------------
LuizAmérico · 2010-02-13 22:57

Quotehttp://sqlite4fpc.yolasite.com/download.php
This is the component that comes with fpc (TSqlite3Dataset unit
sqlite3ds)

You can also use sqldb that comes with fpc

Luiz

----------------------------------------------------------------------
djalil · 2010-02-14 11:48

Thanks for reply luiz .

Where i can find it !! ?

----------------------------------------------------------------------
marcov · 2010-02-14 11:59

Quote from: djalil on February 14, 2010, 12:48:27 pmThanks for reply
luiz .

Where i can find it !! ? 

These are in the default installs of FPC+Lazarus. In the case of
Lazarus, you might have to install SQLDB over packages ->"configure
installed packages"

----------------------------------------------------------------------
djalil · 2010-02-14 12:19

I found just SQLite3Connection1  not sqlitedataset !!

----------------------------------------------------------------------
Zoran · 2010-02-14 14:37

In Lazaraus menu go to "Package", then "Open package file (.lpk)..."

In open dialog go to your Lazarus
folder\components\sqlite\sqlite3laz.lpk and open it. Compile and
install the package.

----------------------------------------------------------------------
djalil · 2010-02-14 18:01

thanks for help
i find it it works fine in windows  

but a problem with wince !!!!

there is no database & their component works well in wince ?

----------------------------------------------------------------------
Paul Breneman · 2010-02-18 00:58

See this tutorial:  Using Sqlite3 with Fcl-Db
http://leonardorame.blogspot.com/2007/11/using-sqlite3-with-fcl-
db.html

That recently worked good for me for WinCE 4.2 with just FreePascal
and fpGUI (no Lazarus).

----------------------------------------------------------------------
Zaher · 2010-02-19 00:38

if you are using only queries and commands to SQLite (no Dataset), you
can use
https://sourceforge.net/projects/minilib/
trunk/MiniConnection/db/sqlite/
It is work in WinCE

----------------------------------------------------------------------
BPak · 2010-02-19 03:58

I tried to do this and get a problem...
QuoteIn Lazaraus menu go to "Package", then "Open package file
(.lpk)..."

In open dialog go to your Lazarus
folder\components\sqlite\sqlite3laz.lpk and open it. Compile and
install the package.
"This application has failed to start because sqlite3.dll was not
found. Re-installing the application may fix this problem."

Lazaraus just wont start now.

Where does the sqlite3.dll need to be placed?

How do I fix please?

----------------------------------------------------------------------
LuizAmérico · 2010-02-19 10:17

Put in the system folder (C:\Windows) or add a custom folder (C:\lib)
to your path where you can put third party dll.

In the client machine is only necessary to put in the same directory
of the executable