既存のクエリ レイヤーから情報を取得

Sub GetQueryLayerInfo()
    Dim pMxDoc As IMxDocument
    Set pMxDoc = ThisDocument
         
    Dim pFL As IFeatureLayer
    Set pFL = pMxDoc.FocusMap.Layer(0)
     
    Dim pDataset As IDataset
    Set pDataset = pFL
     
    Dim pQueryTableName As IQueryTableName
    Set pQueryTableName = pDataset.FullName
     
    Dim pQueryDescription As IQueryDescription
    Set pQueryDescription = pQueryTableName.QueryDescription
     
    Debug.Print pQueryTableName.Query   'クエリの変更
     
    Dim pDatasetName As IDatasetName
    Set pDatasetName = pQueryTableName
     
    Dim pWorkspaceName As IWorkspaceName
    Set pWorkspaceName = pDatasetName.WorkspaceName
     
    Dim pPropertySet As IPropertySet
    Set pPropertySet = pWorkspaceName.ConnectionProperties
     
    Dim vName As Variant
    Dim vValue As Variant
    pPropertySet.GetAllProperties vName, vValue
     
    Dim i As Integer
     
    For i = 0 To pPropertySet.Count - 1
        Debug.Print vName(i), vValue(i)
    Next i
 
    pMxDoc.ActiveView.Refresh
    pMxDoc.UpdateContents
     
End Sub