FiveTech Software tech support forums

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?

Vilian,

Do you mean using FiveTouch or FWH ?

Fivetouch.

Vilian,

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

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

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?

QT provides support for SqlLite (FiveTouch uses QT):

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

But Can I use the same way to use MySql ?

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 ?

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

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

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

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

vilian wrote: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?

This is evertyhing I have in Fivetouch directory: