sqlMS.Initialize(mdlShared.GetDriverClass,mdlShared.GetJDBC_urs(workingFolder, strConfigFile))
If sqlMS.IsInitialized = True Then
'-------------------------------------------------------------------------------------------
Dim sql As String = "select top 1 enterprise_name, enterprise_id from enterprise where delete_ind = 'N' order by enterprise_id"
Dim SenderFilter As Object = sqlMS.ExecQueryAsync("SQL", sql, Null)
Wait For (SenderFilter) SQL_QueryComplete (Success As Boolean, rs As ResultSet)
If Success Then
sqlMS.BeginTransaction
Do While rs.NextRow
cboEnt.Value = rs.GetString("enterprise_name")
strDefaultEntName = rs.GetString("enterprise_name")
strDefaultEntID = rs.GetString("enterprise_id")
Loop
rs.Close
sqlMS.TransactionSuccessful
Else
Log(LastException)
mdlShared.LogErrorToFile("loadSQLEntPrac.1", LastException.Message)
sqlMS.Rollback
End If
'--------------------------------------------------------------------------------------------
sql = "select enterprise_name, enterprise_id from enterprise where delete_ind = 'N' order by enterprise_id"
Dim SenderFilter As Object = sqlMS.ExecQueryAsync("SQL", sql, Null)
Wait For (SenderFilter) SQL_QueryComplete (Success As Boolean, rs As ResultSet)
If Success Then
sqlMS.BeginTransaction
Do While rs.NextRow
cboEnt.Items.Add(rs.GetString("enterprise_name"))
Loop
rs.Close
sqlMS.TransactionSuccessful
Else
Log(LastException)
mdlShared.LogErrorToFile("loadSQLEntPrac.2", LastException.Message)
sqlMS.Rollback
End If
'--------------------------------------------------------------------------------------------
sqlMS.Close
End If