Migrate from DBFCDX TO SQL

[fouednoomen]

yes by my mysql manager i can acces to my database

[Rathinagiri]

Can you show me the code?

[fouednoomen]

please find in this attached file the code

regards
foued

[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.

[fouednoomen]

yes you can check in attached file project

regards

Foued

[Rathinagiri]

You have to delete the sql.prg.

[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

[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" )

[fouednoomen]

it's ok

many thanks


Foued

[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