A very weird problem I have run into. Unpredictably, when I execute the following line code, it will bail out of the method without throwing an error.
RsAlarmDefaults= db.SQLSelect("SELECT * FROM " + Tbl )
RsAlarmDefaults= db.SQLSelect("SELECT * FROM " + Tbl ) dbMessage= db.ErrorMessage dbErrorNo =db.ErrorCode if db.Error = true then Return db.ErrorCode end if RecordCount = RsAlarmDefaults.RecordCount If RecordCount= 1 And UpdateProperties = True Then FillVars Return RecordCount Exception e as RuntimeException Dim Logs As New clsLogging Dim Flds() As String = array("EXCEPTION", "cls" +Tbl + ".getAll ", Cstr( e.Type) ) Logs.AddFields Flds Logs.LogFileAppend( Logs.K_Except_App_Err)
This happens something like every other time, but I have not yet found the rhythm to it yet.
Has anyone else seen this or have an idea how to solve? BTY this is one example, it will occur in other code too but always at the SQL Select code line.
Happens in 2017R3 and 2019R1.1