Recent

Author Topic: Is there an other component for Sqlite Dataset ?  (Read 11386 times)

djalil

  • New Member
  • *
  • Posts: 10
Is there an other component for Sqlite Dataset ?
« on: February 13, 2010, 10:02:53 pm »
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..
« Last Edit: February 13, 2010, 10:04:31 pm by djalil »

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 458
Re: Is there an other component for Sqlite Dataset ?
« Reply #1 on: February 13, 2010, 11:57:00 pm »
Quote
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

  • New Member
  • *
  • Posts: 10
Re: Is there an other component for Sqlite Dataset ?
« Reply #2 on: February 14, 2010, 12:48:27 pm »
Thanks for reply luiz .

Where i can find it !! ?  :(


marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 7438
Re: Is there an other component for Sqlite Dataset ?
« Reply #3 on: February 14, 2010, 12:59:25 pm »
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

  • New Member
  • *
  • Posts: 10
Re: Is there an other component for Sqlite Dataset ?
« Reply #4 on: February 14, 2010, 01:19:41 pm »
I found just SQLite3Connection1  not sqlitedataset !!

Zoran

  • Hero Member
  • *****
  • Posts: 1459
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Is there an other component for Sqlite Dataset ?
« Reply #5 on: February 14, 2010, 03:37:13 pm »
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

  • New Member
  • *
  • Posts: 10
Re: Is there an other component for Sqlite Dataset ?
« Reply #6 on: February 14, 2010, 07:01:28 pm »
thanks for help
i find it it works fine in windows   :D

but a problem with wince !!!!

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

Paul Breneman

  • Sr. Member
  • ****
  • Posts: 290
    • Control Pascal
Re: Is there an other component for Sqlite Dataset ?
« Reply #7 on: February 18, 2010, 01:58:04 am »
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).
Regards,
Paul Breneman
www.ControlPascal.com

Zaher

  • Hero Member
  • *****
  • Posts: 571
    • parmaja.com
Re: Is there an other component for Sqlite Dataset ?
« Reply #8 on: February 19, 2010, 01:38:33 am »
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

  • Newbie
  • Posts: 3
Re: Is there an other component for Sqlite Dataset ?
« Reply #9 on: February 19, 2010, 04:58:09 am »
I tried to do this and get a problem...
Quote
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

  • Sr. Member
  • ****
  • Posts: 458
Re: Is there an other component for Sqlite Dataset ?
« Reply #10 on: February 19, 2010, 11:17:16 am »
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