Changing params

[mieszkom]

Hi,
is any way to programtycaly change DB params by MyServerControl?

[AndreyZ]

Hello,

Please specify the exact database parameters that you want to change.

[mieszkom]

There are global parameters like server_id or max_allowed_packet. When I execute included in help statement:

Code: Select all

MyServerControl1.Variables['max_allowed_packet'] := '1234567890';

I get an error: #HY000SESSION variable 'max_allowed_packet' is read only. Use SET GLOBAL to assign a value.

SQL command using TMyScript "set global ...." works but I want to use TMyServerControl because it looks easier.

[AndreyZ]

To avoid the problem, you should specify the scope of a variable in the variable name. Here is a code example:

Code: Select all

MyServerControl1.Variables['global max_allowed_packet'] := '1234567890';

[mieszkom]

It works, tkank you very much

[AndreyZ]

I am glad I could help.