Zeoslib Portal

no, sorry this is a MySQL issue...

We fixed it by adding a new method: GetAffectedRowsFromLastPost
http://www.heidisql.com/forum/viewtopic ... 8dabbc2768

DBMS: MySQL Zeos: 6.5.1 Alpha The RowsAffected property seems only to be updated when an application sends a query with ExecSQL(). It is not updated when updates, deletes or inserts are done by using a dbgrid. In this case i find that RowsAffected is always 0 in an AfterPost-event from a TZQuery. Hm...

puuh.. that exceeds my delphi-knowledge... Tried to insert a connection-parameter for the Loggingevent.Create but only got errors. don't know - maybe I have to live with that issue.

I found that ZSQLMonitor is quite useful for logging-purposes. The only thing I find very unpracticle is that it logs events from simply all ZConnection's I am using in a application. Even when I have 2 MDI-windows each containing 1 ZConnection + 1 ZSQLMonitor, both of the ZSQLMonitor's log also eve...

the big problem with these functions (CheckScapeString, EscapeCString, QuotedStr) is that they only escape the mostly needed things as quotes, doublequotes and maybe 1 or two other characters. MySQL_real_escape_string is somewhat more complex and would be the best choice. For example it escapes char...

OK, sounds quite easy Will try it this evening and let you know if it works.

Anse

hi, in my experiance this is a general issue with the mysql-server, which cuts off connections if they are idle for a specific time and other clients are waiting to get a connection. You have to know that the server only allows a specific amount of connections from all clients, which is by default a...

Aahhh.... It really seems to be the Properties of the ZConnection. Try to set compress=1 and then, after being connected, execute this SQL-command: show status like "compr%" It correspondents with the value set in the properties! And the good info: We now know that the "Info"-lis...

The Unit ZDBCMySQL reads and sets the option "compress" on the "Open"-procedure: procedure TZMySQLConnection.Open; ... { Turn on compression protocol. } if StrToBoolEx(Info.Values['compress']) then FPlainDriver.SetOptions(FHandle, MYSQL_OPT_COMPRESS, nil); { Sets connection timeo...

Yes, I am using the alpha 6.5.1 for HeidiSQL :) I noticed the ZConnection-property "Catalog". What does it stand for? Is it probably the represention of the current database, which I can set and get rid of all problems I had ? I always thought I have to set the "Database"-propert...

thanks for the reply, mdaems. I am setting the database property before I execute the "select ...", but it doesn't seem to effect something. For the moment I have fixed the problem by commenting the 4 lines out and removing database from the internal queries (as described above). By the wa...

How can I only log queries which are assigned to one of more ZConnection's ? The latest CVS-version of ZSQLMonitor is 2 years old and no earlier version also has a "Connection"-property for this purpose. So if I have 2 connections and 2 ZSQLMonitor objects, the OnLogTrace of both Monitor-o...

ok... ist seems more simple than I thought :) - My ZConnection initially has the database-property set to "Information_schema" (this is the first database on the server) - then a ZQuery executes ('USE ' + secondDBname) - then another ZQuery executes ('SELECT * FROM ' + tableFromSecondDB) -...

I just found this in my mysql-query.log: ... 78 Query SHOW TABLES FROM information_schema LIKE 'channels' 78 Query SHOW COLUMNS FROM information_schema.channels LIKE '%' These queries are fired by ZDbcMysqlMetadata funcs "GetTables" and "GetColumns" and I think "GetKeys"...

Thanks a lot for trying to debug to all guys! But sorry I have to disappoint some of you. I have applied the hack from mdaems and get another errormessage when opening a simple resultset with a ZQuery, TDataSource and a TDBGrid : SQL Error: Unknown table 'channels' in information_schema. Maybe I'm s...