I have a Table which has a column works as“auto_identity”
I want to point to the last value of this column and then in another table read the value of that.
SQL1 = "insert into Table1 values (" + Lnum + ", 'REFER' , '" + Dt + "', '" + RunDt.ToString() + "', @@IDENTITY )";
conn.Execute(SQL1, out returnRecords, 0);


int i = 1;
foreach (string s in split)
         {

SQL2 = "insert into Table2 values ('read the value of the identity column', " + i + ", '" + s + "')";
conn.Execute(SQL2, out returnRecords, 0);
    ++i;
         }
would you help pls

thanks

My code is in C#.

__________________
--------------------
Thanks
Rose
[email protected]

Oh God noone answered!!!!!!!!!!
here is the task that I got the great result by that.

public int Execute(string stringSQL, bool bGetIdent)
    {
        // open connection if it is closed.
        if (conn.State == System.Data.ConnectionState.Closed)
            conn.Open();
        // Build a connection and SQL strings
        string SQL;
        if (bGetIdent)
        {
            SQL = "SET NOCOUNT ON;\n";
            SQL += stringSQL + ";\n";
            SQL += "SELECT @@IDENTITY AS Ident;\n";
            SQL += "SET NOCOUNT OFF;\n";
        }
        else SQL = stringSQL;
        // Create command object
        Microsoft.Data.Odbc.OdbcCommand cmd = new Microsoft.Data.Odbc.OdbcCommand(SQL);
        cmd.Connection = conn;
        // Call command's ExecuteScalar
        int returnID = 0;
        object returnObject = cmd.ExecuteScalar();
        if (bGetIdent)
            if (returnObject != null)
                returnID = System.Convert.ToInt32(returnObject.ToString());
        return returnID;
    }

hope it helps ...