The below code does a basic SUM count of the hours in a table in SQL. The problem, is that if you look at the query, its based on the EmpID. Where, there will be some cases where the employee's information will not yet be in the table, and when this query detects that, a error comes up. How can I prevent the error? So if my EmpID was "3355" and my EmpID was not in the table, I would get an error.
Dim sConn2 As String = "DSN=TriumphODBC"
Dim myConn2 As New OdbcConnection(sConn2)
Dim sSQL2 As String = "SELECT SUM (Hours) FROM HR_VacationDates WHERE [Date] <= GETDATE() AND EmpID = '" & Trim(strVacation_EmployeeID) & "' AND Approved = '2'"
Dim myCommand2 As New OdbcCommand(sSQL2, myConn2)
lblHoursUsed.Text = myCommand2.ExecuteScalar.ToString
Catch ex As Exception
If myCommand2.Connection.State = ConnectionState.Open Then