TMyServerControl exsample needed

TheLion · Post by **TheLion** » Thu 18 Aug 2005 12:01

Hi

I am using Delphi5 and MyDac 3.55.0.22

I need to know how to get and set system variables like Max_Connections using TMyServerControl or something similar

Best regards
Flemming Brandt

GEswin · Post by **GEswin** » Thu 18 Aug 2005 13:07

Do a

Code: Select all

show variables

from a TMyQuery and you'll obtain variables from mysql server. Refer to mysql docs for more details about this.

Regards

Guest · Post by **Guest** » Thu 18 Aug 2005 14:17

Hi

I know the show variables command.

In the help file under TMyServerControl it only sais:

procedure ShowVariables;
Description
Use this method to show the current state of the server.
See Also
ShowStatus

I would like to know if it was posible to list/get a single variable and then set the variable to a different setting.

Guest · Post by **Guest** » Thu 18 Aug 2005 14:29

Hi

I don't know what is wrong with the forum today!!! I look up in the corner and I can see that I (TheLion) am logged in. But when I submitted my answer It was as a guest!!!

But I would still like an exsample on how to set a system variable. I thought that it could be done through TMyServerControl.

GEswin · Post by **GEswin** » Thu 18 Aug 2005 21:40

Attach a TDatasource+TDBGrid to the TMyServerControl and you'll see it filled with the variables.

Ikar · Post by **Ikar** » Mon 22 Aug 2005 08:14

Use SHOW VARIABLES LIKE 'Max_Connections' to get values and SET Max_Connections for setting.

Please see MySQL Reference for details