SQL stmt produces Error 0

[holly]

Hi

I have this SQl Stmt in one of my procedure but it produces an error 0 on execute...
Can anyone spot the obvious?

_strSql = " update tbl_scale_event SET " & _
               " EVENT_DATETIME = '" & finalDateTime & "', " & _
               " SCALE_NUMBER = '" & CInt(StrScaleNumber) & "', " & _
               " EVENT_STATUS = '" & CStr(Event_Status) & "', " & _
               " Operator_badge = '" & Strshift & Replace(strBadge, " '", "''") & "', " & _
               " Operator_Lastname = '" & Replace(strLast_Name, "'", "''") & "' " & _
               " MANUGACTURE_DATETIME = '" & (finalDateTime) & "'," & _
               " WHERE " & _
               " Scale_Event_ID = '" & (ObjRSprodidvalues.Fields(0).Value) & "'"
               
     m_Intwndprogress = 30
        'if accepted display users Input/executes and initiates a scale transaction
            objOcn.Execute l_strSql 'execute SQL statement

Thanks