For OLE DB SQL, I have retrieved the primary key:
-----------------------------
using (System.Data.OleDb.OleDbConnection oledbConnect = new
System.Data.OleDb.OleDbConnection(stConnectString))
{
using (System.Data.OleDb.OleDbCommand oledbCmd =
oledbConnect.CreateCommand())
{
...
oledbCmd.ExecuteNonQuery();
//Retrieve the ID
oledbCmd.CommandText = "Select @@Identity";
int iKeyID = (int)oledbCmd.ExecuteScalar();
stKeyID = iKeyID.ToString();
-----------------------------
What is the correct nomenclature for SQLite?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
