How can I prevent TMyQuery from opening a new connection ?

[dormky 2]

query := TMyQuery.Create(nil);
query.Connection := conn;
query.SQL.Text := 'SELECT * FROM data';
query.Execute();

Every time I do something like this, a new connection to the MySQL server is established. How can I make it use the already-opened 'conn' connection ?

Thanks 🙂

[TheBioh4z4rdx 0]

try to do "query.Open" for Select statements instead of "query.Execute()"

[Brian Evans 108]

MySQL can only have one running/open query per connection.  What you are seeing is normal for MySQL.