Need Help to Understand Code

[Pete]

I'm in my 60s and now I do comment, spell out descriptive variable names, and indent. I really miss the "old" days... when I wasn't so damn old!

Mt database stuff was probably around 50,000 records, so we are miles apart in this area. You may want to start up a discussion with Steve, just on managing techniques. I don't think he has worked with MySQL, but he has worked on some commercial billion record systems.

Pete

[SMcNeill]

MySQL experience is effectively zip with regards to trying to use it with QB64.  The only times I’ve ever had to work with SQL was for localized database access, so I’ve never needed to sort out online query information/protocols and such.  Much of my database work (when I was getting paid to do it), was written back in the day with DBASE IV or FoxPro 2.0 (and higher), and I’ve even written converters for DBF files so we can use them easily in QB64.  https://www.qb64.org/forum/index.php?topic=64.msg303#msg303

Unfortunately, those aren’t what you’re looking for here, so I’ve been mostly silent on this subject, hoping someone with more SQL/QB64 integration experience could help answer your questions.  ;)

[TempodiBasic]

Hi
on first I attach the files to work with MySQL  but I got little fortune and bad results...for my actual knowledge of mySQL I think

on second you must correct the code in the example in Wiki...
I'm expert about eating letters on typing so IMHO in the last row before END of the first example there is an "n" less than it should be

mysql_close con

in the example you can see that it is DIMmed conn and not con  [ You are not allowed to view this attachment ]  

[MLambert]

Hi All,

I have been working thru' mysql in wiki and found that it is a very strong piece of code.

It is very hard to read .. but plodding my way thru'.

I have been able to use it ... but at the moment I am checking error return code e.g. select a unique key ... what error return if not found.

I have had help from Fellippe and Juanjogomez

If anyone wants some detail on how to use it just let me know.

When I am finished I will post all of the code in this forum.

By the way I did not know mysql until I started this work ... it is pretty simple and logical. For the clever bits just google.

Mike

[TempodiBasic]

It will be fantastic if in wiki the link mysql.dll was working!
But I have no original file attached to that link, only my downloaded version libmysql.dll from SQL website!

Long life to QB64! And to its contributors...

[Juanjogomez]

Hi,
I do not use the error codes.
When you search for a data using a SELECT, the program returns the data in an array of rows or columns. If the rows are 0, you have not found any data. It's the first thing I check every time I do a search.
Regards

[MLambert]

Hi  Juanjogomez

 When you check for errors ... would you pls show me your code..

Mike