FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Pocket PC Using ADOCE
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Using ADOCE
Posted: Wed Sep 03, 2008 01:20 PM

For MYSQL existe algo?

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Using ADOCE
Posted: Wed Sep 03, 2008 03:28 PM

Já testou o MySQLMobile 1.6 a ligar a uma base de Dados Mysql num servidor NET

Funciona bem no FWPPC ?

Obrigado pela Ajuda

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Using ADOCE
Posted: Wed Sep 03, 2008 08:54 PM

Nosotros no lo hemos probado aún

Asi que te agradecemos que nos comentes tu experiencia :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Using ADOCE
Posted: Wed Sep 03, 2008 10:46 PM

Ok,

Obrigado Linares

Posts: 96
Joined: Tue Jun 17, 2008 09:02 PM
Using ADOCE
Posted: Fri Sep 05, 2008 05:26 PM

an example of as to bring (to convert) the contacts of poutlook wm6 in a file DBF?
Thanks thousand

Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 04:55 PM

Boas
Sr. Linares Estou pedindo tua ajuda no seguinte, ainda não consegui conectar com o LIB MYSQLMOBILE.DLL com o FWPPC, gostaria de pedir tua ajuda e se possível
comunicar com Mouro pois também andou atrás da lib MYSQLMOBILE e não consegui seu contacto

Obrigado
Sérgio

Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 05:21 PM

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

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 05:26 PM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 05:40 PM

o Link para efectuar download:

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

Será que conseguimos o exemplo em FWPPC?

Cumprimentos
Sérgio

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 11:21 PM

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 :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Using ADOCE
Posted: Wed Feb 18, 2009 11:22 PM
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
Code (fw): Select all Collapse
LIBRARY     MYSQLMOBILE.DLL

EXPORTS
    mysql_connect                  @1   ; mysql_connect
    mysql_disconnect               @2   ; mysql_disconnect
    mysql_execute_query            @3   ; mysql_execute_query
    mysql_get_data                 @4   ; mysql_get_data
    mysql_get_field                @5   ; mysql_get_field
    mysql_get_fieldcount           @6   ; mysql_get_fieldcount
    mysql_get_last_error           @7   ; mysql_get_last_error
    mysql_get_last_insert_id       @8   ; mysql_get_last_insert_id
    mysql_get_last_servermessage   @9   ; mysql_get_last_servermessage
    mysql_get_rowcount             @10  ; mysql_get_rowcount
    mysql_select_db                @11  ; mysql_select_db


We create the import library MySQLMobile.lib this way:
c:\vce\bin\lib /def:MySQLMobile.def /machine:ARM

You can download MySQLMobile.lib from here:
http://www.fivetechsoft.com/files/MySQLMobile.lib
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Using ADOCE
Posted: Thu Feb 19, 2009 12:00 AM
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
Code (fw): Select all Collapse
#include "FWCE.ch"

function Main()

   local nRet := MySQL_Connect( "192.168.0.30", 3306, "username", "password" )
   
   MsgInfo( nRet )
   
return nil   

#pragma BEGINDUMP

int mysql_connect( char * host, int iPort, char * username, char * password );

#include <hbapi.h>

HB_FUNC( MYSQL_CONNECT )
{
   hb_retnl( mysql_connect( hb_parc( 1 ), hb_parnl( 2 ), hb_parc( 3 ), hb_parc( 4 ) ) );
}

#pragma ENDDUMP

The EXE properly run :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 88
Joined: Sun May 25, 2008 05:46 PM
Re: Using ADOCE
Posted: Thu Feb 19, 2009 01:08 AM

Excelente! Excellent Linares :D

The Test return 0 (é normal)

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

regards, saludos
Sérgio