Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well.
The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application. Also ZeosDBO 5.3.0 is supposed to be beta. Iago. -----Mensaje original----- De: Kiss Dániel [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 11:33 Para: [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: >Hi all. > >I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using >InnoDB tables and I want to use transactions. > >I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work >I can see the rows inserted in the database >with another connection. > >What is the problem? The WinZeos components is too old? > >Iago. > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
