Lester,
Does Oracle accept insert statements with missing PK fields?
(the DEFAULT constant doesn't work for FB but NULL doesn't work for Postgre)
omitting the PK field completely works for FB and MySQL... Oracle?

Alan

> -----Original Message-----
> From: firebird-php@yahoogroups.com
> [mailto:firebird-php@yahoogroups.com]On Behalf Of Lester Caine
> Sent: Saturday, 9 June 2007 9:50 PM
> To: firebird-php@yahoogroups.com
> Subject: Re: [firebird-php] FireBird/ADODB
>
>
> 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
>
>
>
> Yahoo! Groups Links
>
>
>
>