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
