RE: [PHP-ES] odbc

From: Date: Tue, 07 Nov 2000 16:24:42 +0000
Subject: RE: [PHP-ES] odbc
Groups: php.general.es 
Request: Send a blank email to general-es+get-3386@lists.php.net to get a copy of this message
Si, lo conocia pero es para sql server 7.0 o superior pero el tema es que yo accedo a una base a traves de odbc y la base en este caso es access :( -----Mensaje original----- De: Alejandro Garín [mailto:garin_alejandro@yahoo.com] Enviado el: Martes, 07 de Noviembre de 2000 12:55 p.m. Para: lista@phpes.com Asunto: Re: [PHP-ES] odbc >Ale gracias pero lo que necesito es que atraves de odbc para access o para >sqlserver o para cualquier base de datos me de el ultimo elemnto id >insertado? Encontre esto para Sql server 7, sirve? @@IDENTITY After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY contains the last identity value generated by the statement. If the statement did not affect any tables with identity columns, @@IDENTITY returns NULL. If multiple rows are inserted, generating multiple identity values, @@IDENTITY returns the last identity value generated. If the statement fires one or more triggers that perform inserts that generate identity values, calling @@IDENTITY immediately after the statement returns the last identity value generated by the triggers. The @@IDENTITY value does not revert to a previous setting if the INSERT or SELECT INTO statement or bulk copy fails, or if the transaction is rolled back. Examples This example inserts a row into a table with an identity column and uses @@IDENTITY to display the identity value used in the new row. INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES ('Accountant',12,125) SELECT @@IDENTITY AS 'Identity' saludos, --------------------- Alejandro Diego Garín Telecom Internet -----BEGIN PGP PUBLIC KEY BLOCK----- Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com> mQGiBDoG3UYRBAD9DNDwPQRUg8W1BL5mOBdtHWdCLmPCqH+xt4DUsTHHZC1hgydH ixiFsPELT7w2mTyGYdVJzCWLl2wvqAVNan7YB419U+qveFZ6bVMbaZuR9IMuSLpV LojMZ+P+tArWOa5Nmvo9GYNwM3DBP1GoqSwMt3EKSaH1d+tF2/sqHXSfHQCg/9xV +jfDaQaK4RvusVUwplQy3AMEAJfMAK0elQTRzEFe5BH+zQ8lQ/9LOGT9mUwZ+8ax IAJWEHTzHw/iB2wKRHD3Uf5I65qiN2pgCjKNxD6r7oXJsQS8Rn/2cL+9FJUZ+ncL Yx2MHqKiWsxQ05bTCW3UP8HjaV+eaxvExR7nkUbJt5WImaM1kZhIYPJjORU9GTWC 2wBfBADvMzmFRmWUjzs4i2lnNU10KjRHnHk4Sy0DSZZ+iJ5Zy5vcZzRXT0tLph5n obuysL3CC2Qtc/MWjX1YOofvWT8QSgP4vYOmDrKklF997DlgH7EK0asibvLFLAdP zWpEg79UHqVn6NDI45Yo/p5l/P7h7yukkOdO1pseGFdhwx1HBrQrQWxlamFuZHJv IERpZWdvIEdhcu1uIDxhZ2FyaW5AYXJuZXQuY29tLmFyPokAVAQQEQIAFAUCOgbd RgUJAeEzgAQLAwIBAhkBAAoJEJYLPProARrF3MMAnRQ1Ep0qkeM/Gq/QEGrTq/k9 gaBWAKCUtUabeW4rn4twCxcEO/jPUWcJhrkCDQQ6Bt1GEAgA9kJXtwh/CBdyorrW qULzBej5UxE5T7bxbrlLOCDaAadWoxTpj0BV89AHxstDqZSt90xkhkn4DIO9ZekX 1KHTUPj1WV/cdlJPPT2N286Z4VeSWc39uK50T8X8dryDxUcwYc58yWb/Ffm7/ZFe xwGq01uejaClcjrUGvC/RgBYK+X0iP1YTknbzSC0neSRBzZrM2w4DUUdD3yIsxx8 Wy2O9vPJI8BD8KVbGI2Ou1WMuF040zT9fBdXQ6MdGGzeMyEstSr/POGxKUAYEY18 hKcKctaGxAMZyAcpesqVDNmWn6vQClCbAkbTCD1mpF1Bn5x8vYlLIhkmuquiXsNV 6TILOwACAgf/VUy7yUpXj9MfVlcdJzBMAbj2uIQoWpU9sDRwIPN77BQ+BPi48FWp Kw9zu+XBUbBgsKobOAYFXWTgZNOs+5Snpuss/z2Kw7/GWwW7pyK3SxSZ76w9mQ/4 xIOxfpukp7KP9OhcdMoBDyL1zPFNOEw6sSSMpPlQWUb3HiR9WXm86eNkBJZt+KF/ DKocG4lFQRhk7YqdruX3UgNxJhFxMz5JOW5EkU77YSxYwkyZQFJFwROqWtgTmtOU Zz9VRozsove5O39h5iLkWiecZhKJGAAIOW6braLIHRqO8i6sCflgI1pWAQe2QZTP chxU3TusPY//N7SLESrojKND533t4DnsLYkATAQYEQIADAUCOgbdRgUJAeEzgAAK CRCWCzz66AEaxSnDAKCyea3+Mx32xpEC9bV7112ru/nlvgCgnK3P9cYXfcA++rUK bzvTkQijazU= =djSB -----END PGP PUBLIC KEY BLOCK----- _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Manual PHP en español: http://www.php.net/manual/es/ Para dar de baja la suscripción, mande un mensaje a: lista-unsubscribe@phpes.com

« previous php.general.es (#3386) next »