Using ADOCE


Postby rasptty » Wed Sep 03, 2008 1:20 pm

For MYSQL existe algo?
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Postby Antonio Linares » Wed Sep 03, 2008 1:41 pm

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 41205
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby rasptty » Wed Sep 03, 2008 3: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
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Postby Antonio Linares » Wed Sep 03, 2008 8: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
User avatar
Antonio Linares
Site Admin
 
Posts: 41205
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby rasptty » Wed Sep 03, 2008 10:46 pm

Ok,

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

Postby xfood » Fri Sep 05, 2008 5:26 pm

an example of as to bring (to convert) the contacts of poutlook wm6 in a file DBF?
Thanks thousand
xfood
 
Posts: 96
Joined: Tue Jun 17, 2008 9:02 pm

Re: Using ADOCE

Postby rasptty » Wed Feb 18, 2009 4: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
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Postby rasptty » Wed Feb 18, 2009 5: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
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

Postby Antonio Linares » Wed Feb 18, 2009 5: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
User avatar
Antonio Linares
Site Admin
 
Posts: 41205
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Using ADOCE

Postby rasptty » Wed Feb 18, 2009 5: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
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Re: Using ADOCE

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

Re: Using ADOCE

Postby Antonio Linares » 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: Select all  Expand view
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: 41205
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Using ADOCE

Postby Antonio Linares » 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: Select all  Expand view
#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
User avatar
Antonio Linares
Site Admin
 
Posts: 41205
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Using ADOCE

Postby rasptty » Thu Feb 19, 2009 1: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
rasptty
 
Posts: 88
Joined: Sun May 25, 2008 5:46 pm

Next

Return to FiveWin for Pocket PC

Who is online

Users browsing this forum: No registered users and 2 guests