SqlLite OR MySql

[vilian]

Hi Antônio,

I would like to develop an app that can work with these two databases. Do you know if is possible to use both with the same code? only changing the initial connection?
I'm not intended use both at the same time, but some users want or need SqlLite and other choose to use Mysql.

Is it possible ? how?

[Antonio Linares]

Vilian,

Do you mean using FiveTouch or FWH ?

[vilian]

Fivetouch.

[Antonio Linares]

Vilian,

You have to use a Web service so you can manage any database engine

viewtopic.php?f=33&t=31621&start=0

[vilian]

Antônio,
Do I must to do the server of webservice?
I was thinking that SqlLite is the internal database of Android, isn't it ? How to do a webservice for it?

[Antonio Linares]

QT provides support for SqlLite (FiveTouch uses QT):

https://katecpp.wordpress.com/2015/08/28/sqlite-with-qt/

[vilian]

But Can I use the same way to use MySql ?

[Antonio Linares]

http://doc.qt.io/archives/qt-4.8/sql-connecting.html

[vilian]

Antônio,

I believe it's that I want, but I don't how to use this code in Fivetouch ! I have tried by this way, but don't worked !

#include "FiveTouch.ch"

function Main()
LOCAL oBD

oDB := QSqlDatabase()
oDB:addDatabase("QMYSQL")
oDB:setHostName("10.10.1.1")
oDB:setDatabaseName("fox_sgv")
oDB:setUserName("root")
oDB:setPassword("Xxxx")
oDB:open()

RETURN NIL

But, when I try run the app, is shown a message of Undefined Function QSQLDATABASE. Could you help me ?

[cnavarro]

Your code is correct, but

Para que este código compile bien, es necesario que se añada el módulo sql al proyecto, es decir al fichero *.pro con la linea:

QT+=sql

[vilian]

In my directory of Fivetouch there are no files *.pro

[cnavarro]

You do not have/use the project fivetouch.pro?

[vilian]

No,
I'm using Fivetouch Version that Antônio has published here http://forums.fivetechsupport.com/viewtopic.php?f=32&t=35529

[cnavarro]

No,
I'm using Fivetouch Version that Antônio has published here http://forums.fivetechsupport.com/viewtopic.php?f=32&t=35529

Folder Windows, not?

[vilian]

This is evertyhing I have in Fivetouch directory: