Search found 4 matches

by stiank81
17.03.2006, 12:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to implement transactions?
Replies: 10
Views: 4444

True indeed.. Well - yes, I guess this is a good time to do the update. Thanks for good help anyway!

Stian
by stiank81
17.03.2006, 11:45
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to implement transactions?
Replies: 10
Views: 4444

Thanks, great. How could I miss the function "StartTransaction". It is in my version as well, and sounds like something I should use! I've tried, but without luck :( Here is what I write now. ZMySqlQuery.Transaction.AutoCommit := False; ZMySqlQuery.Transaction.StartTransaction; ZMySqlQuery...
by stiank81
17.03.2006, 10:13
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to implement transactions?
Replies: 10
Views: 4444

Hi. I'm sorry about the late reply - I've been away for a while.. I'm not trying to do any altering of the database structure. What I'm doing is inserting, updating and deleting records. So, yes I thought you should be able to do rollbacks then. But is the code to do it witch I submitted above corre...
by stiank81
03.03.2006, 14:52
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How to implement transactions?
Replies: 10
Views: 4444

How to implement transactions?

Hi. I'm trying to implement transactions with Zeos and mysql, but I can't make it work... The mysql tabels are InnoDB, so transactions should be available. Here is an example: ZMySqlQuery.Transaction.AutoCommit := False; ZMySqlQuery.Close; ZMySqlQuery.Sql.Clear; ZMySqlQuery.Sql.Add(query); ZMySqlQue...