The SQLRDD library for Harbour and MiniGUI

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
gfilatov
Posts: 1074
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gfilatov »

Hi Friends,

More good news :!:

I tried to rewrite the MySqlCli example of Minigui using the SQLRDD library.

You can see the result of this program in the picture below:
image2.png
image2.png (33.5 KiB) Viewed 75663 times
Your feedback is welcome. :)
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
gisjr134
Posts: 44
Joined: Tue Dec 08, 2020 11:37 am
DBs Used: DBF,MySQL,PostgreSQL
Location: Brasil
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gisjr134 »

Hi All ,


For insert records into the DataBase Table(MySql) , Will DbAppend() Work This Way ? Or Will i Have To Execute a Insert into Command?
Using This SQLRDD

Greetings to All
User avatar
gfilatov
Posts: 1074
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gfilatov »

gisjr134 wrote: Sat Dec 30, 2023 9:33 pm Hi All ,


For insert records into the DataBase Table(MySql) , Will DbAppend() Work This Way ? Or Will i Have To Execute a Insert into Command?
Using This SQLRDD
Hi,

Yes, sure.
DbAppend() function works fine with SQLRDD.
For an example, see the first post in this discussion. :idea:
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
gisjr134
Posts: 44
Joined: Tue Dec 08, 2020 11:37 am
DBs Used: DBF,MySQL,PostgreSQL
Location: Brasil
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gisjr134 »

Thank's ,

Happy New Year For EveryOne.
gisjr134
Posts: 44
Joined: Tue Dec 08, 2020 11:37 am
DBs Used: DBF,MySQL,PostgreSQL
Location: Brasil
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gisjr134 »

I Got This Error When Compiling and Building The Demo Project described above With the libsqlrdd.a avaible for download here in this thread.

c:/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible c:/hmg/lib-64\libsqlrdd.a when searching for -lsqlrdd
c:/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lsqlrdd

I Think it might be The b4 bit Version of habour and mingw i'm using. Some kind of confilct , i don't Know.
User avatar
gfilatov
Posts: 1074
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gfilatov »

gisjr134 wrote: Sun Dec 31, 2023 7:33 pm I Got This Error When Compiling and Building The Demo Project described above With the libsqlrdd.a avaible for download here in this thread.

c:/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible c:/hmg/lib-64\libsqlrdd.a when searching for -lsqlrdd
c:/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lsqlrdd

I Think it might be The b4 bit Version of habour and mingw i'm using. Some kind of confilct , i don't Know.
You are correct.
This libsqlrdd.a file is for a 32-bit HMG, but your environment is 64-bit.

BTW I also have a 64-bit version of SQLRDD for all MiniGUI Ex donors.

For details, see viewtopic.php?p=70595#p70595. :arrow:

Hope this was helpful. :idea:
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
gisjr134
Posts: 44
Joined: Tue Dec 08, 2020 11:37 am
DBs Used: DBF,MySQL,PostgreSQL
Location: Brasil
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gisjr134 »

Hi ,

Can I Compile It in Harbour\MingW 64 Bits ? The SQLRDD ..
User avatar
gfilatov
Posts: 1074
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gfilatov »

gisjr134 wrote: Tue Jan 02, 2024 2:51 pm Hi ,

Can I Compile It in Harbour\MingW 64 Bits ? The SQLRDD ..
Hi,

Yes, sure.

You will need the following software: :arrow:

1) the sources of the SQLRDD library have been updated to work with MySQL versions above 5.1;
2) Harbour make tool hbmk2 project file to create this library with a 64-bit version of \MingW.

That's all :idea:
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
gisjr134
Posts: 44
Joined: Tue Dec 08, 2020 11:37 am
DBs Used: DBF,MySQL,PostgreSQL
Location: Brasil
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gisjr134 »

Hi ,


What is This Error ? Bison?

Build64 /n /b SqlRdd.Hbp

lder\xHarbour-SQLRDD\source>buildexe release
Compilando..
hbmk2: Processando opções do ambiente: -comp=mingw64
hbmk2[SqlRdd]: plugin: HB_BISONPATH not set, could not autodetect 'bison.exe'
executable
User avatar
gfilatov
Posts: 1074
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: The SQLRDD library for Harbour and MiniGUI

Post by gfilatov »

gisjr134 wrote: Tue Jan 02, 2024 10:07 pm Hi ,


What is This Error ? Bison?

Build64 /n /b SqlRdd.Hbp

lder\xHarbour-SQLRDD\source>buildexe release
Compilando..
hbmk2: Processando opções do ambiente: -comp=mingw64
hbmk2[SqlRdd]: plugin: HB_BISONPATH not set, could not autodetect 'bison.exe'
executable
Hi,

You should set the HB_BISONPATH environment variable to determine the path to the required bison.exe application, i.e.
SET HB_BISONPATH=%ProgramFiles%\GnuWin32\Bin
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
Post Reply