FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Sqllite
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Sqllite
Posted: Sat May 18, 2013 02:08 PM

here in my town many people use sqllite , why we cannot use it with fwh?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Sqllite
Posted: Sat May 18, 2013 02:21 PM

We CAN use it with FWH.
I'am using it with ADO.

Sended with Tapatalk

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: Sqllite
Posted: Sat May 18, 2013 02:37 PM

Marc,

Can you post a small sample program using ADO and SQLite?

Regards,
James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Sqllite
Posted: Sat May 18, 2013 03:32 PM

The beauty of ADO is that it is engine aware (with some caveats...). You only have to change the connection string et voilà. :-)

EMG

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Sqllite
Posted: Sat May 18, 2013 05:34 PM
James Bott wrote:Marc,

Can you post a small sample program using ADO and SQLite?

Regards,
James


James,

Just like Enrico is saying, you only have to change the connection-string and install the sqlite-connector.
In a topic about FiveDBU I sended the connection-string for SQLite
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=26229&start=17

For the rest, it's working like MySQL, MariaDB,..
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: Sqllite
Posted: Sat May 18, 2013 09:58 PM

I tried with fwdbu BUt I not Know how open a db file ( sqllite)

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 858
Joined: Fri Oct 07, 2005 12:00 PM
Re: Sqllite
Posted: Sun May 19, 2013 04:49 PM

Hi Silvio,
there is a Sqlite class for FWH to use directly the Sqlite API (faster then ADO).
I'm using it from three years. Check on the forum.

Best Regards,



Marco Turco

SOFTWARE XP LLP
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: Sqllite
Posted: Sun May 19, 2013 05:47 PM

PUOI INVIARMI STA CLASSE PER FAVORE ?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Sqllite
Posted: Sun May 19, 2013 06:58 PM
Marco Turco wrote:Hi Silvio,
there is a Sqlite class for FWH to use directly the Sqlite API (faster then ADO).
I'm using it from three years. Check on the forum.


Marco,

I used to use that also before, and it was also working very nice.
I have some customers that still use that version of my program.
I switched to ADO-SQLite because it was easyer to use the same program for MySQL and SQLite, only change the connection-string.
I use SQLite for stand-alone versions, and MySQL for network-versions.
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Sqllite
Posted: Sun May 19, 2013 11:40 PM
I switched to ADO-SQLite because it was easyer to use the same program for MySQL and SQLite, only change the connection-string.


This is the one great advantage of using ADO, when compared with other specific libraries.

Now, Mr Mark,
Where to find the OLEDB provider for SqLite? I see only priced providers.
Regards



G. N. Rao.

Hyderabad, India
Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: Sqllite
Posted: Mon May 20, 2013 12:53 AM
Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: Sqllite
Posted: Mon May 20, 2013 09:33 AM

on Xageslite of Xailer use Sqllite Db Files native

http://www.ozs.com/?q=xaGeslite
On this application I not see extern Dll and my computer not have Odbc Driver Sqllite installed,
ho w this app run good ?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: Sqllite
Posted: Mon May 20, 2013 09:56 AM

Silvio,

Their Database class supports either DBF, ADO, MySQL, etc. Same class and at start you indicate datasoruce.

Maybe Fivetech could add support to ADO into TDBF class?.

Thanks.

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.

Continue the discussion