HMG 3.6 (64 bit version)

Moderator: Rathinagiri

Red2
Posts: 273
Joined: Sat May 18, 2019 2:11 pm
DBs Used: Visual FoxPro, FoxPro
Location: United States of America

Re: HMG 3.6 (64 bit version)

Post by Red2 »

Hello Rathi and Grigory,

When the 3.6 Setup file link was posted it was stated, "I am sharing the setup file for your testing and comments."

Quick Question:
In the future will there be a "final" 3.6 Setup file that includes the relevant "testing and comments" feedback?

Again, thank you for all of your generous contributions!
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HMG 3.6 (64 bit version)

Post by Rathinagiri »

Red2 wrote: Fri May 12, 2023 3:15 pm Hello Rathi and Grigory,

When the 3.6 Setup file link was posted it was stated, "I am sharing the setup file for your testing and comments."

Quick Question:
In the future will there be a "final" 3.6 Setup file that includes the relevant "testing and comments" feedback?

Again, thank you for all of your generous contributions!
Yes, I am working for a final version which is containing all the fixes mentioned in this topic. I am happy that people are contributing 64 bit libraries for many APIs. I have compiled for MariaDB/MySQL server which also requires the libmysql.dll also 64n bit. Let me share later.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
tonton2
Posts: 444
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Contact:

Re: HMG 3.6 (64 bit version)

Post by tonton2 »

Rathinagiri wrote: Sat May 13, 2023 11:07 am
Red2 wrote: Fri May 12, 2023 3:15 pm Hello Rathi and Grigory,

When the 3.6 Setup file link was posted it was stated, "I am sharing the setup file for your testing and comments."

Quick Question:
In the future will there be a "final" 3.6 Setup file that includes the relevant "testing and comments" feedback?

Again, thank you for all of your generous contributions!
Yes, I am working for a final version which is containing all the fixes mentioned in this topic. I am happy that people are contributing 64 bit libraries for many APIs. I have compiled for MariaDB/MySQL server which also requires the libmysql.dll also 64n bit. Let me share later.
merci beaucoup
L'Algerie vous salut
Y.TABET
jorge.posadas
Posts: 174
Joined: Mon May 19, 2014 7:43 pm
DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
Location: Morelia, Mich. México
Contact:

Re: HMG 3.6 (64 bit version)

Post by jorge.posadas »

Yes, I am working for a final version which is containing all the fixes mentioned in this topic. I am happy that people are contributing 64 bit libraries for many APIs. I have compiled for MariaDB/MySQL server which also requires the libmysql.dll also 64n bit. Let me share later.

Excelente yo empiezo a hacer pruebas con MariaDB y me da gusto que en esta version de 64b se empiece a ver MariaDB, es algo que tengo mucho interes en aprender.

Felicidades por esta version de 64b era algo que estaba esperando desde hace tiempo
Cordialmente

POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Morelia, Mich.
M é x i c o .
Movil +52 44 3734 1858
SKYPE: jorge.posadasch
Email: posoft@gmx.com
User avatar
serge_girard
Posts: 3167
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: HMG 3.6 (64 bit version)

Post by serge_girard »

Thanks Jorge, let me know about libmysql.dll and MariaDB/MySQL server!

Serge
There's nothing you can do that can't be done...
Red2
Posts: 273
Joined: Sat May 18, 2019 2:11 pm
DBs Used: Visual FoxPro, FoxPro
Location: United States of America

Re: HMG 3.6 (64 bit version)

Post by Red2 »

I have done some more testing of the initial (3.6) HMG 64-bit build.

It appears to me that Jimmy's Debugger improvement, his "ON DBLCLICK"
improvement, is not available in this initial 64-bit build.
See: viewtopic.php?f=12&t=6173&p=59887

HMG.3.5 includes this feature but it does not work in 3.6.
Could you consider adding this improvement to 3.6?

Thank you!
Red2
Posts: 273
Joined: Sat May 18, 2019 2:11 pm
DBs Used: Visual FoxPro, FoxPro
Location: United States of America

Re: HMG 3.6 (64 bit version)

Post by Red2 »

May I suggest one small and easy improvement in HMG' IDE?
It would be clearer (example here is in English) if item #31 in the IDE's ".ANS" language file was charged from:
Delete File
to
Remove file from Project

The phrase "Delete File" can (incorrectly) suggest deletion from the File System.
Thank you for your consideration.
User avatar
serge_girard
Posts: 3167
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: HMG 3.6 (64 bit version)

Post by serge_girard »

The phrase "Delete File" can (incorrectly) suggest deletion from the File System.
Indeed !

Serge
There's nothing you can do that can't be done...
edk
Posts: 914
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland

Re: HMG 3.6 (64 bit version)

Post by edk »

hblibxlsxwriter 64 bit little progress.

I compiled the latest version of libxlsxwriter (https://github.com/jmcnamara/libxlsxwriter).
I used MSYS2 (https://www.msys2.org/) and the mingw64 package (https://packages.msys2.org/package/ming ... po=mingw64) - installation: pacman -S mingw-w64-x86_64-gcc
This is how I got the libxlsxwriter.dll library.

Then I used the latest wrapper for Harbor (https://github.com/FTrautwein/hblibxlsxwriter) to compile the libhblibxlsxwriter.a library.

I tried to run a test demo, but as Jimmy wrote (http://hmgforum.com/viewtopic.php?p=627 ... 46f#p62736), loading libxlsxwriter.dll returned me Nil also.
It turned out that zlib1.dll is also needed for libxlsxwriter.dll to load.
zlib1.dll is used to compress the output xlsx file.

The test program was already running, but when calling the pointers in the libxlsxwriter.dll library, errors such as:
Unrecoverable error 6005: Exception error:

Exception Code:C0000005 ACCESS_VIOLATION
Exception Address:00007FF97F26B518


In the hblibxlsxwriter.prg wrapper, I changed the library call from

Code: Select all

hb_DynCall( { cProc, nHDll, HB_DYN_CALLCONV_SYSCALL }, ... )
to

Code: Select all

hb_DynCall( { cProc, nHDll, hb_bitOr( HB_DYN_CTYPE_VOID_PTR, HB_DYN_CALLCONV_STDCALL ) }, ... )

Now the test application creates the demo.xlsx file, but there is another problem, namely all numeric variables sent to the library return the value 0.

I'm guessing it might be a problem with these pointers, but here I am stuck, my knowledge of C is limited and I can't figure it out any further.

Maybe someone, something...

I send the installation of the hblibxlsxwriter add-on: https://megafile.cc/kjrg/install-alpha- ... g-36exe.7z

The add-on will be installed in c:\hmg.3.6\Add-On\hblibxlsxwriter\
Wrapper sources: c:\hmg.3.6\Add-On\hblibxlsxwriter\hblibxlsxwriter.prg

To compile the wrapper and generate the libhblibxlsxwriter.a library, run the script c:\hmg.3.6\Add-On\hblibxlsxwriter\build_hblibxlsxwriter.bat

Test application source: c:\hmg.3.6\Add-On\hblibxlsxwriter\test\demo.prg
Compiling the test application: c:\hmg.3.6\Add-On\hblibxlsxwriter\test\bl64.bat

libxsxwriter sources: c:\hmg.3.6\Add-On\hblibxlsxwriter\libxlsxwriter_1.1.5-Core\
libxlsxwriter.dll 64 bit: c:\hmg.3.6\Add-On\hblibxlsxwriter\libxlsxwriter_1.1.5-Core\lib\libxlsxwriter.dll
zlib1.dll 64 bit: c:\hmg.3.6\mingw64\bin\zlib1.dll
edk
Posts: 914
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland

Re: HMG 3.6 (64 bit version)

Post by edk »

There is a problem with the console mode under hmg.3.6: if I set the GT driver in the sources: REQUEST HB_GT_WIN_DEFAULT, the application starts but the console window is not visible, you have to kill the application via the task manager.
Post Reply