Sqllite

[Silvio.Falconi]

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

[Marc Vanzegbroeck]

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

Sended with Tapatalk

[James Bott]

Marc,

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

Regards,
James

[Enrico Maria Giordano]

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

EMG

[Marc Vanzegbroeck]

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,..

[Silvio.Falconi]

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

[Marco Turco]

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.

[Silvio.Falconi]

PUOI INVIARMI STA CLASSE PER FAVORE ?

[Marc Vanzegbroeck]

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.

[nageswaragunupudi]

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.

[cnavarro]

Mr. Rao
http://forums.fivetechsupport.com/viewtopic.php?f=6&t=24283&p=131276&hilit=sqllite#p131271

[Silvio.Falconi]

on Xageslite of - 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 ?

[lucasdebeltran]

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.