Zeoslib Portal

This patch has been added to zeos testing branch (REV 314) and will be included in Zeoslib 6.6 unless somebody experiences serious trouble. It looks very safe, however, as it only has effects when you deliberately add new connection options to the TZConnection.Properties setting. marcocot , thanks,...

Sure! Where should I post it?

This may be done using a trick. If you add a 'set' statement to the my.cnf init-command parameter you should be able to execute it at every connect. I need to write security information, so it won't be the right place. You can use an application specific cnf file by adding MYSQL_READ_DEFAULT_FILE=<...

Hello,
I need to inizialise a global variable to mysql server during a connection. Is there a way to include the initizialization in TZConnectio component? maybe in params property? I actually excute a separated query with a SET statement.

thanks
Marco

Hello, I have a simple table with an autoincrement field. I have dropped a TZQUERY and aTZUpdateSQL. Just to test I filled Zquery.SQL property with SELECT * FROM atable and filled the sql properties of the TZUpdateSQL component with the proper statentemnts. I tryied working in autocommit mode: Zquer...

add string 'CLIENT_MULTI_STATEMENTS=1' to property ZConnection1.Properties Also : to retrieve the value of the @variable try 'select @variable;' Mark thanks for your reply. Unfurtunately nothing have changed. I tryied this simple procedure: CREATE DEFINER = 'root'@'%' PROCEDURE `new_proc`(OUT _VALU...

add string 'CLIENT_MULTI_STATEMENTS=1' to property ZConnection1.Properties Also : to retrieve the value of the @variable try 'select @variable;' Mark thanks for your reply. Unfurtunately nothing have changed. I tryied this simple procedure: CREATE DEFINER = 'root'@'%' PROCEDURE `new_proc`(OUT _VALU...

Try to use this statement : SET @ID_AGENTE_EMAILS_SRCDB=:ID_AGENTE_EMAILS_SRCDB;CALL APPEND_AGE_EMAIL(:IS_DEFAULT,:ID_AGENTE_SRCDB,:ID_AGENTE,:E_MAIL,:ID_STATO_EMAIL,@ID_AGENTE_EMAILS_SRCDB); Sorry, I didn't test it... I could not try it myself, as I have changed my code... But I got the same probl...

Hello, I am having this excepion raised when I try to pass to a stored procedure an TZSQLUPDATE component param. "SQL Error: OUT or INOUT argument 6 for routine venditori.APPEND_AGE_EMAIL is not a variable or NEW pseudo-variable in BEFORE trigger." here what I wrote in INSERTSQL property: ...

Hello, I feel a little confusing about the functionality of transaction isolation and locking.Hoping someone can help me. Lets suppose 2 transactions work on the same record I call them T1,T2. T1 start transaction before T2. T2 commit before T1 here what I got: Serializable, I got dead lock error o...

Hello to anyone, I need lock a record to prevent other uses to modify/delete it. I use SELECT.. FOR UPDATE using TZquery. The problem is the second user stand still waiting for the first user to commit or roll back its transaction and the application freezing. I there a way to break this waiting? M...

Hello to anyone, I need lock a record to prevent other uses to modify/delete it. I use SELECT.. FOR UPDATE using TZquery. The problem is the second user stand still waiting for the first user to commit or roll back its transaction and the application freezing. I there a way to break this waiting? Ma...

Hello, I feel a little confusing about the functionality of transaction isolation and locking.Hoping someone can help me. Lets suppose 2 transactions work on the same record I call them T1,T2. T1 start transaction before T2. T2 commit before T1 here what I got: Serializable, I got dead lock error on...

Hello to anyone, I have a complex select with a join. But I can't get joined fields when I am using cached updates. Without using cached updates I can solve refreshing the dataset, but refreshing with cached updates makes losting . the records. Should I use lookup fields instead of joins? Or there'...

Hello to anyone, I have a complex select with a join. But I can't get joined fields when I am using cached updates. Without using cached updates I can solve refreshing the dataset, but refreshing with cached updates makes losting . the records. Should I use lookup fields instead of joins? Or there's...