ISProviderVers.ReferenceSystem

Example

Display the full name, ID and reference system of the provider in the selected provider version.

sub main()

  Dim aFilter 
  Dim aProviders
  Dim aDate
  Dim aMessage

  Set aFilter = Profile.CreateProvidersFilter
  aFilter.Category = 2 'pcProvider
  aFilter.Code = "VE3"

  set aProviders = Profile.LoadProvidersByFilter(aFilter)

  aDate = #06/10/2019#
  aMessage = GetProviderCollectionInfo(aProviders, aDate)

  Profile.MsgBox(aMessage)
end sub


function GetProviderCollectionInfo(aProviders, aDate)
  Dim aProvider
  Dim aProviderOnDate
  Dim aInfo
   
  aInfo = ""

  for each aProvider in aProviders
    aInfo = aInfo & vbNewLine & vbNewLine & "PROVIDER: " &_
      aProvider.FullName & vbNewLine

    set aProviderOnDate = aProvider.VersionOnDate(aDate)
    if aProviderOnDate is nothing then    
      aInfo = aInfo & vbNewLine & " - " & aProvider.FullName &_
        " (" & aProvider.Id & ") " & "  -  No Version on this date"
    else 
      set aReferenceSystem = aProvider.ReferenceSystem
      set aReferenceSystemVers = aProviderOnDate.ReferenceSystem           
      aInfo = aInfo & vbNewLine & "CURRENT VERSION: " & vbNewLine &_
        "Full Name: " & aProvider.FullName & vbNewLine & "ID: " & aProvider.Id &_
        vbNewLine & "Reference System: " & aReferenceSystem.Description & vbNewLine &_
        vbNewLine & "VERSION ON DATE:  " & vbNewLine & "Full Name: " &_
        aProviderOnDate.FullName & vbNewLine & "ID: " & aProviderOnDate.Id &_
        vbNewLine & "Reference System: " & aReferenceSystemVers.Description
    end if 
  next   
  GetProviderCollectionInfo = aInfo
end function