MySQL :: Re: How do you get the @@identity for the record just inserted?

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: How do you get the @@identity for the record just inserted?

Posted by: Timothy Graupmann
Date: January 23, 2005 04:08PM

Got the SELECT @@IDENTITY to work with this:

// Get Id from Insert
myCommand = myConnection.CreateCommand();
myCommand.CommandText = "SELECT @@IDENTITY";
newMeshNode.MeshNodeId =
(UInt32)(Int64)myCommand.ExecuteScalar();
if(newMeshNode.MeshNodeId == 0)
throw new Exception("Invalid MeshNodeId was assigned.");

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 12:54PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 12:58PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:38PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:48PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:52PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 04:08PM

Re: How do you get the @@identity for the record just inserted?

Reggie Burnett

January 24, 2005 08:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.