Page 3 of 4
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 7:55 am
by fouednoomen
yes by my mysql manager i can acces to my database
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 8:03 am
by Rathinagiri
Can you show me the code?
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 8:25 am
by fouednoomen
please find in this attached file the code
regards
foued
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 8:30 am
by Rathinagiri
Why did you include sql.prg in your project?
I think when you call connect2db, the one in sql.prg is called and hmgmysql is neglected.
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 8:37 am
by fouednoomen
yes you can check in attached file project
regards
Foued
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 9:12 am
by Rathinagiri
You have to delete the sql.prg.
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 12:24 pm
by fouednoomen
Thanks radhi ,
Now every thinks it's ok but the combobox of recouv does not work
@ 150,690 ComboBOX Control_6 FONT 'Arial' SIZE 11 WIDTH 220 ;
DISPLAYEDIT
ITEMSOURCE REPRESEN->COD_REP+' '+REPRESEN->RAISON
aTable := sql( oDB, "select cod_rep || ' ' || raison from represen order by cod_rep" )
for i := 1 to len( aTable )
win_1.control_6.additem( aTable[ i, 1 ] )
next i
regards
Foued
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 12:42 pm
by Rathinagiri
For string concatenation MySQL is different from SQLite.
You have to use this:
aTable := sql( oDB, "select concat( cod_rep, ' ', raison ) from represen order by cod_rep" )
Re: Migrate from DBFCDX TO SQL
Posted: Wed May 22, 2013 2:11 pm
by fouednoomen
it's ok
many thanks
Foued
Re: Migrate from DBFCDX TO SQL
Posted: Thu May 23, 2013 11:49 am
by Mario Mansilla
Hola Foued :
disculpa la molestia este proyecto de migrar cdx a mysql es algo por distintas razones se me posterga . Me es muy util el post que abriste .
Podrias decirme con que version de mysql estas trabajando y de donde puedo obtener el mysql manager .
Saludos .
Mario Mansilla
Hello Foued:
sorry for the inconvenience this project to migrate to mysql cdx is something for different reasons I postponed. I find it very useful post you opened.
Could you tell me what version of mysql are working and where I can get the mysql manager.
Greetings.
Mario Mansilla