Using ADOCE

rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Post by rasptty »

For MYSQL existe algo?
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

regards, saludos

Antonio Linares
www.fivetechsoft.com
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Post by rasptty »

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

Funciona bem no FWPPC ?

Obrigado pela Ajuda
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

Nosotros no lo hemos probado aún

Asi que te agradecemos que nos comentes tu experiencia :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Post by rasptty »

Ok,

Obrigado Linares
xfood
Posts: 96
Joined: Tue Jun 17, 2008 9:02 pm

Post by xfood »

an example of as to bring (to convert) the contacts of poutlook wm6 in a file DBF?
Thanks thousand
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Post by rasptty »

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
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Post by rasptty »

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
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Using ADOCE

Post by Antonio Linares »

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
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Post by rasptty »

o Link para efectuar download:

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

Será que conseguimos o exemplo em FWPPC?

Cumprimentos
Sérgio
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Using ADOCE

Post by Antonio Linares »

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
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Using ADOCE

Post by Antonio Linares »

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: Select all

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
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Using ADOCE

Post by Antonio Linares »

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: Select all

#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 :-)
Image
regards, saludos

Antonio Linares
www.fivetechsoft.com
rasptty
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Post by rasptty »

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
Post Reply