SQL Problem (The MAX Function Requires 1 Argument(s).)

Hey Guys,

I'm having problems with my SQL statement and Im wondering if anyone could help?  My code is below.

The Label6 is filled up using a previous SQL Statement, and when Ive had a fiddle around it is using the KnowledgeID It works in reading in the date, it just doesnt appear to want to work for the second statement as I am getting the error shown in the subject.

Thanks in advance =)

C# Codeprotected void Button2_Click(object sender, EventArgs e)

{KnowledgeID = Convert.ToInt32(Label5.Text);

string path = Server.MapPath(" ") + "\X_Drive\";FileLocation = path + Convert.ToString(FileUpload1.FileName);SqlConnection myConnection = new SqlConnection(myConnectionString);

 SqlCommand myCommand2 = new SqlCommand("select * from Knowledge WHERE KnowledgeID = '" + KnowledgeID + "'", myConnection);

myConnection.Open();

SqlDataReader myReader = myCommand2.ExecuteReader();if (myReader.HasRows)

{while (myReader.Read())

{Add = myReader["DateAdded"].ToString();

}

myReader.Close();

}

else

{

myConnection.Close();

}

 SqlTransaction trans = myConnection.BeginTransaction();

{

try

{

 SqlCommand myCommand3 = new SqlCommand("Select ISNULL(MAX(Version,0)+1 FROM Archive WHERE KnowledgeID = "+KnowledgeID+"",myConnection);

myCommand3.Transaction=trans;int nextVersion =(int)myCommand3.ExecuteScalar();if (File != null)

{myCommand3 = new SqlCommand("INSERT INTO Archive (FixName, Description, Location, DateAdded, DateArchived, Version, KnowledgeID) SET (@FixName,@Description,@File,@Add,@AddDate,@SAPPS,@Version,'" + KnowledgeID + "')", myConnection);

}

else

{myCommand3 = new SqlCommand("INSERT INTO Archive (FixName, Description, DateAdded, DateArchived, Version, KnowledgeID) SET (@FixName,@Description,@Add,@AddDate,@SAPPS,@Version,'" + KnowledgeID + "')", myConnection);

}myCommand3.Parameters.AddWithValue("@FixName", TextBox1.Text);

myCommand3.Parameters.AddWithValue("@Description",TextBox2.Text);myCommand3.Parameters.AddWithValue("@File",FileLocation);

myCommand3.Parameters.AddWithValue("@Add",Add);myCommand3.Parameters.AddWithValue("@AddDate",AddDate);myCommand3.Parameters.AddWithValue("@Versions",nextVersion);

myCommand3.ExecuteNonQuery();

trans.Commit();

}catch (Exception ex)

{

//TextBox2.Text = ex.Message;

trans.Rollback();

myConnection.Close();

}

//}