SQLCODE in Cobol

[franco]

I know select from code, but I do not open database I only use tables as I need.
In Foxpro I use select from Mytable, fields, where somthing, into table temp, for something
When I try Dragans sample I get libmysql.dll not found. Where is a good place to get libmysql.dll.

[dragancesu]

File libmysql.dll is part of MySQL instalation

...\mysql\bin\libmysql.dll

and just copy in aplication folder

[franco]

Which website would I get mysql from ? Microsoft.

[dragancesu]

Ask google for mysql
Oracle is owner now

[Claudio Ricardo]

Hola... Dento de HeidiSQL están todas las .dll
Subo la que uso yo y funciona perfecto tanto para MySql como para MariaDB !
Hay que copiarla a la carpeta del proyecto.

Hi... Inside HeidiSQL have all .dll
I use this and work perfect with MySql and MariaDB !
Put it in the project folder.

[franco]

Thank for help. Claudio, I got the SQL`S. I still can not get Dragon`s or Serge`s to work. As Serge suggeted I think I will Start a new thread.
I am Tied up gor a while.

[serge_girard]

Franco, do you have a database allready? SQL is not as complicated as you think but first you need a database...

Serge

[dragancesu]

I think one of the easiest ways to start with MySQL https://www.uniformserver.com/
download, unpack and run

Note: this is the local version, if you need a real server install MySQL database
contains apache and php, it doesn't matter

[serge_girard]

And SQL is much fun!

[franco]

I can not say,

select name from customer
// or
select * from customer
I use tables not a database.
Now I use index to temp (created from seconds()) and seems to do all i used to do in Foxpro with select from.