I have two questions:
1- If you send multiple queries to the server using the TMyCommand.Execute method, the sql server only parses and executes the first query, while the second is desregarded.
If you do the same thing using the TMyQuery.Open, then all queries are parsed and executed by the Server. How come there is this difference ?
If you log the queries by the server and look at them, there is no difference in what ther server gets. So how can this occur ?
2- In the documentation it says that the TMyQuery. Execute method implicitly calls prepare, and calls open. I cannot see a prepare query in the MySQL query log. Does that mean that no prepare is called, or just that a call to prepare dos not show up there ?? And besides I do not want an implicit call to prepare to be made. How can I prevent this ?
I have also a couple of comments and suggestions:
A) In the documentation, if you go to the MyQuery and click on "Properties", you will find a derived property: Autocommit. This is actually not derived in implimentation, as one cannot refer to it in MyQuery object
B)The MyConnection has a preperty called "Embedded" and another preperty called "Options.Embedded" is this some form of redundency ? would you kindly correct this ?
C) In the MyConnection there are two properties: "Options.Direct" and "Options.Embedded" I wonder whether it is not better to declare this as an enumerated type instaed of booleans. for example:
TserverInterface = (siDirect, siEmbedded);
Options.ServerInterface: TServerInterface
This would make more sense, because the connection type can only be true for either Embedded or Direct at any given time. It cannot be both
Thanks in advance
