Link to home
Start Free TrialLog in
Avatar of chrisryhal
chrisryhal

asked on

Error in simple SUM Query

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)
        Try
            myCommand2.Connection.Open()
            lblHoursUsed.Text = myCommand2.ExecuteScalar.ToString
        Catch ex As Exception
        Finally
            If myCommand2.Connection.State = ConnectionState.Open Then
                myCommand2.Connection.Close()
            End If
        End Try
        myConn2.Close()
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chrisryhal
chrisryhal

ASKER

Like a charm.  Thanks!!!!