syntax error executescalar

[Hansduncan]

I'm getting a syntax error when debugging the code on the following line. disc1ID = CType(mycmd.ExecuteScalar(), Integer) in the below code. All the error give me to go on is syntax error. ??? Any idea what the problem could be? Private Sub NewToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewToolStripButton.Click Dim mycmd As New SqlCommand("SELECT MAX(DiscountId) AS discID FROM(Discountstructure)", MDIParent1.Conn) mycmd.CommandType = CommandType.Text Dim disc1ID As Integer MDIParent1.Conn.Open() disc1ID = CType(mycmd.ExecuteScalar(), Integer) MDIParent1.Conn.Close() MsgBox(disc1ID.ToString) End Sub

[Guffa]

Remove the parentheses around the table name.

--- single minded; short sighted; long gone;