Is there an other component for Sqlite Dataset ?

[djalil]

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]

http://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]

Thanks for reply luiz .

Where i can find it !! ? 

[marcov]

Thanks 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]

I found just SQLite3Connection1  not sqlitedataset !!

[Zoran]

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]

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]

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]

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]

I tried to do this and get a problem...

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.

"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]

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