It's easy to upgrade. I just did a search and replace in the .dfm files. Fredrick ----- Original Message ----- From: "Informatica Handem" <[EMAIL PROTECTED]> To: "Kiss Dániel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 3:00 AM Subject: RE: WinZeos and Transactions
> 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 > > --------------------------------------------------------------------- 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