SQL client

[Juanjogomez]

Hello,
I have tried the example to work with SQL client, but it does not work with tables of more than 1 field. Only display the first. Can someone pass me the code to work with tables of several fields (the usual)?
Regards

[FellippeHeitor]

Hi there Juanjogomez, and welcome to the Forum.

I assume you're talking about http://www.qb64.org/wiki/SQL_Client

I don't remember anyone using that code for any real world projects, to be honest. Hope you can find a solution soon.

Fellippe.

[Juanjogomez]

Well, I was going to be the first. I have a billing program in QuickBasic and I thought to use Sql to update it
Thanks

[Juanjogomez]

Good news,
I went back to try the code and it works perfectly. With a table of 40 columns it reads all the data perfectly.
I am considering rewriting the entire program, including Inform, although it will take many months because it is a billing management program with 65 subprograms and I do not have much time.
I'll tell you if I decide to do it.
Thank you

[TerryRitchie]

Where did you obtain mysql.dll since the .NET link is down? Could you possibly attach your copy here please?

[TempodiBasic]

Hi
it seems that MySQL is version 5.6 used in examples of wiki made by Galleon
https://dev.mysql.com/downloads/mysql/5.6.html#downloads

[TerryRitchie]

Thank you for the link Tempo.

[TempodiBasic]

Hi guys
I have gone depeer in the search of Mysql.dll

here the results:
1.
I downloaded before MySQL.DLL version 5.7, because I find first its link, but I get error !!!
So on one hand I have thought that it is not the real version used in the examples of wiki made by Galleon and I must get the right version of .DLL, but on the other hand I have thought that it seems very unuseful to make innovations without backward compatibilty... so I must get the right version of .DLL version 5.6

2.
to get the right file I download the complete system of MySQL for client and for server... and as you can see from pictures attached
on first I got MySQL.DLL version 5.6 32bit and examples on wiki works for a second and then I get the error1 posted as screenshot.
Why 32bit ? Because the

This page was last modified on 19 January 2013, at 23:25.

and Galleon talks about also QB64 SDL version...
However I got MySQL.DLL version 5.6 64bit after getting error1! But I have had another surprise! Please see at screenshot named error2. That is showed is the same error that I got with MySQL.DLL version 5.7! :-)

Here I attach a zipfile with the 3 Mysql.DLL  ver 5.6 32 bit , ver 5.6 64bit and ver 5.7 32 bit.

Who can confirm (have) the same results on his system?

Thanks to read

[TempodiBasic]

I have forgotten the link for info

https://dev.mysql.com/doc/#topic
https://dev.mysql.com/doc/refman/5.6/en/c-api-functions.html

to download
https://dev.mysql.com/downloads/installer/
To try code you need only MySQL Connectors, but I raccomande you to download the server if you must go deeper with MySQL
https://dev.mysql.com/downloads/mysql/

[SMcNeill]

If you're using QB64 from the github repository, or from www.qb64.org, then you're using the standard 32-bit version of QB64 and need the 32-bit DLL to work with it.

Only if you're using QB64x64 from my site, (or built it on your own), will you need a 64-bit DLL.

If you're uncertain what you're running, just compile and test this:

Code: QB64: [Select]

1. $IF 32BIT THEN
2.    PRINT "You are on QB64 x32"
3. $ELSE
4.     PRINT "You have QB64 x64"
5. $END IF

[bplus]

Could just look at the top left corner of your IDE too.

[SMcNeill]

Could just look at the top left corner of your IDE too.

Except it's not always there (such as when you load a program and it displays the filename there).

_TITLE ideprogname + " - QB64"   <--- Like here.

Honestly, I guess it should always say "x64" or "x32", but I've just never taken the effort to search for all the places where _TITLE exists.

[bplus]

I had not noticed that it changes with _TITLE but it is always there when I start up the IDE.

It would be nice in the About message from Help menu, but that would depend on compiling?

[TempodiBasic]

Hi guys

I have QB64IDEx32 and so it must use mysql.dll at 32bit.
But Running examples 1 and 2  taken from wiki about SQL I got that it works just for one max two seconds than it crashes and  the manager of crushing of windows starts like you can see in attachment called Error1.

The point of my message was

Here I attach a zipfile with the 3 Mysql.DLL  ver 5.6 32 bit , ver 5.6 64bit and ver 5.7 32 bit.

Who can confirm (have) the same results on his system?

Thanks

[Juanjogomez]

Hi.

I do not know what version I use of mysql.dll because I downloaded it some time ago. It works perfectly for me on 64-bit windows 7.

If you want I can send it to you to try it.