Re: [PHP4BETA] DB in PEAR and other questions

Hello Alan, On 06-May-00 15:33:08, you wrote: >I think that Andrew has raised a very valid question. Mysql doesnt support >transactions and the PEAR DB class returns a constant to identify this. Why >shouldnt this occur in the reverse situation for a DBMS that supports >transactions but not last insert id ?? Because using auto-incremented fields is not the end in itself, but rather a means to get a sequential unique integer value that will be used as key in one or more tables. Other DBMS like Oracle, PostgreSQL and others use sequences to achieve this. So, it's more logical and objective to abstract sequences portably than to abstract auto_increment fields that not only are not supported at all in several important DBMS, but also impose some requirements on the fields on which they are set. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --