FiveTech Software tech support forums

Getting the fieldnames: test.prg #include "FWCE.ch"#define MYSQL_PORT  3306function Main()   local nRet := MySQL_Connect( "SQL06.FREEMYSQL.NET", MYSQL_PORT, "fivetech", "fivewin" ) // username, password   local nFields, cFieldName      if nRet ...

A live test against http://www.FreeMySQL.net: test.prg #include "FWCE.ch"#define MYSQL_PORT  3306function Main()   local nRet := MySQL_Connect( "SQL06.FREEMYSQL.NET", MYSQL_PORT, "fivetech", "fivewin" ) // username, password      if nRet == 0  ...

Doing a SQL query: test.prg #include "FWCE.ch"#define MYSQL_PORT  3306function Main()   local nRet := MySQL_Connect( "192.168.0.30", MYSQL_PORT, "username", "password" )      if nRet == 0      M...

Selecting the database to work with: test.prg #include "FWCE.ch"function Main()   local nRet := MySQL_Connect( "192.168.0.30", 3306, "username", "password" )      if nRet == 0      MsgInfo( "successful connection" )      nRet ...

A new version with disconnect support: test.prg #include "FWCE.ch"function Main()   local nRet := MySQL_Connect( "192.168.0.30", 3306, "username", "password" )      if nRet == 0      MsgInfo( &qu...

A new test.prg with mysql errors support: test.prg #include "FWCE.ch"function Main()   local nRet := MySQL_Connect( "192.168.0.30", 3306, "username", "password" )      if nRet == 0      MsgInfo( "successful connection" )   els...

Sergio,

> The Test return 0 (é normal)

Yes, it is ok!

It means connected!

>
Podemos tentar Ligar
MyExeQuery ? - Executar uma query
MySelectDb ? - Abrir Base de Dados
MyDesconec ? - Desconectar
>

Yes, lets do it

Dear Mr.Antonio and Mr.Sergio, Thankyou very much for the info and the sample :D . I was looking for a solution on how a FWPPC application can access a MYSQL Database installed on a server and MySQL support on Windows Mobile devices. I understand that MySQLMobile is a commercial software. I hope tha...

Excelente! Excellent Linares

The Test return 0 (é normal)

Podemos tentar Ligar
MyExeQuery ? - Executar uma query
MySelectDb ? - Abrir Base de Dados
MyDesconec ? - Desconectar





regards, saludos
Sérgio

Sergio, Here you have a first test. You have to add this line to FWPPC\samples\buildce.bat after the last used library: echo MySQLMobile.lib >> msvc.tmp test.prg #include "FWCE.ch"function Main()   local nRet := MySQL_Connect( "192.168.0.30", 3306, "usernam...

MySQLMobile.dll demo version can be downloaded from here: http://www.fivetechsoft.com/files/MySQLMobile.dll We create the MySQLMobile.def file this way: impdef.exe MySQLMobile.def MySQLMobile.dll MySQLMobile.def LIBRARY     MYSQLMOBILE.DLLEXPORTS    mysql_connect                  @1 ...

Sergio,

Excelente! Excellent!

Now that we have MySQLMobile.dll we can fully use it from FWPPC!
Ahora que tenemos MySQLMobile.dll podemos usarlo totalmente desde FWPPC

o Link para efectuar download:

http://www.briweb.net/software/c/sourcecode.rar

Será que conseguimos o exemplo em FWPPC?

Cumprimentos
Sérgio

Sergio,

> O Exemplo em http://classic.pocketgear.com feito C++ eVC4.0 funciona OK, estando o source code disponivel

Puedes copiar aqui el código fuente de ese ejemplo con C++ eVC4.0 ? gracias

O Exemplo em http://classic.pocketgear.com feito C++ eVC4.0 funciona OK, estando o source code disponivel será que podemos utilizar
em FWPPC

Fiz vários testes com o exemplo e funcionou sempre OK (UPDATE, INSERT, SELECT .......)

Cumprimentos
Sergio