Error al compilar con HMG3.6

[edk]

hbmk2[Motel]: Warning: Cannot find hbmysql=hbmysql.hbc (referenced from
C:\hmg.3.6\hmg64.hbc)

Check the file C:\hmg.3.6\hmg64.hbc, it should contain the notation libs=hbmysql.hbc, not hbmysql=hbmysql.hbc

[mjaviergutierrez]

Gracias por su respuesta edk, ahora me dice esto ....

[edk]

Try to install Microsoft Visual C++ Redistributable: https://aka.ms/vs/17/release/vc_redist.x64.exe
What version of MySQL/MariaDB do you use?

[mjaviergutierrez]

Hola ! ,
reinstale Microsoft Visual C++ Redistributable y anduvo perfecto, estoy usando MySQL :
con la versión HMG3.6 (64Bits) y MySQL 5.5 (64Bits) funciona perfecto (usando la nueva dll )
HMG3.6 (64Bits) y MySQL 8.0.4.0 (64Bits) , nueva dll , NO funciona. Da un error al conectar con el server.
Ahora, con HMG.3.5 (32Bits) y MySQL 8.0.4.0 (64 Bits), con la vieja dll , funciona ...
No sé ...

[edk]

For MySQL versions newer than 5.5, use the libmysql.dll file, which is distributed with MySQL Server.
For version 8.0, the file can be found in the folder: C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.dll

[serge_girard]

Edward,

Everything works fine except my data retrieved from SQL database is shown without French and German accents (like é ç ü). It is correctly retrieved but when displayed on a Form accents are ignored.
What do I miss?

Serge

[edk]

Hi Serge.
Do you have the data in the SQL database encoded in the same code page as your application? I have the encoding in UTF8 in SQL and in the application. Polish accents are written, retrieved and displayed correctly.

[serge_girard]

Hi Edward,

collatie server: utf8mb4_unicode_ci
charset: cp1252 (west european latin1)

Nothing changed after switching from HMG3.44 to HMG3.6....

Serge

[edk]

For testing, check that it correctly converts the resulting string from SQL UTF8 using the hb_utf8ToStr( <cSQLUTF8Str> ) function.

[serge_girard]

Edward,

I get this result:

Code: Select all

 
aCurRow1    := cQuery1a:GetRow(1)
cNM1        := strvalue(aCurRow1:fieldGet(1)  )
cNM2        := hb_utf8ToStr(aCurRow1:fieldGet(1)  )
? 'cNM1', cNM1
? 'cNM2', cNM2
 

cNM1 Elénore Amable François
cNM2 Elénore Amable François

Both are OK but result on my form is this: