Alan McDonald wrote:

> Lester,
> off topic....
> all my research on mysql Vs mysqli (www.mysql.com) reads that it (the i
> version) (interalia) has improved protocol OTW and provides for statement
> preparation..
> But the comments and code in ADODB is more clearly attempting to state that
> mysqli offers transaction control.
> Do you know anything here? I always thought that mysql requires transaction
> tables (e.g. innodb) to provide for anything that you or I would consider
> transactions in FB speak.
> Or is there something else here I'm missing?

I don't bother about MySQL, but I do know that the mysqli driver is needed for
ANY new version of MySQL. The mysql is maintained for compatibility with older
versions? Transactions do depend on which table type you select, and a lot of
the 'claimed' facilities are only available under specific configurations.
Getting something 'firebird like' needs a lot of care, something I think Jim
is now finding and I don't think we have yet seen any off his MySQL work released?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird Foundation Inc. - http://www.firebirdsql.org/index.php