Page 3 of 4
Re: Error al compilar con HMG3.6
Posted: Thu Dec 12, 2024 12:59 am
by edk
mjaviergutierrez wrote: ↑Wed Dec 11, 2024 6:38 pm
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
Re: Error al compilar con HMG3.6
Posted: Thu Dec 12, 2024 7:13 pm
by mjaviergutierrez
Gracias por su respuesta edk, ahora me dice esto ....
Re: Error al compilar con HMG3.6
Posted: Thu Dec 12, 2024 10:11 pm
by 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?
Posted: Mon Dec 16, 2024 9:34 pm
by 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é ...
Re: Error al compilar con HMG3.6
Posted: Mon Dec 16, 2024 10:13 pm
by 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
Re: Error al compilar con HMG3.6
Posted: Thu Dec 19, 2024 1:45 pm
by 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
Re: Error al compilar con HMG3.6
Posted: Thu Dec 19, 2024 10:33 pm
by 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.
Re: Error al compilar con HMG3.6
Posted: Fri Dec 20, 2024 8:14 am
by 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
Re: Error al compilar con HMG3.6
Posted: Fri Dec 20, 2024 12:39 pm
by edk
For testing, check that it correctly converts the resulting string from SQL UTF8 using the hb_utf8ToStr( <cSQLUTF8Str> ) function.
Re: Error al compilar con HMG3.6
Posted: Fri Dec 20, 2024 1:22 pm
by 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: