-----Original Message----- From: Jordan Sparks [mailto:jspa...@free-dental.com] Sent: Wednesday, November 17, 2004 1:02 PM To: dot...@lists.mysql.com Subject: RE: Last insert autoincrement id value with VB.NET

I don't know of one. But remember that you can simply build a function to encapsulate that behavior. For instance, I have:

public int NonQ(string command){ return NonQ(command,false); }

public int NonQ(string command,bool getInsertID){ cmd.CommandText=command; int rowsChanged=0; try{ con.Open(); rowsChanged=cmd.ExecuteNonQuery(); if(getInsertID){ cmd.CommandText="SELECT LAST_INSERT_ID()";

dr=(MySqlDataReader)cmd.ExecuteReader(); if(dr.Read())

InsertID=PIn.PInt(dr[0].ToString()); } } catch(MySqlException e){ MessageBox.Show("Error: "+e.Message+","+cmd.CommandText); } //catch{ // MessageBox.Show("Error: "+); //} finally{ con.Close(); } return rowsChanged; }

I know it's C#, but you should be able to follow it. Basically, the second function does all the work, but is overloaded in the first function. So, throughout my code, I can either call DataConnection.NonQ("some string"), or I can call DataConnection.NonQ("some string",true). Then DataConnection.InsertID will contain the last increment id. I'm sure my function above could be a little more elegant, but it get's the job done.