Subversion Repositories DevTools

Rev

Rev 6070 | Rev 6579 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6070 Rev 6289
Line 127... Line 127...
127 
         "       )"&_
 127 
         "       )"&_
128 
         "ORDER BY UPPER(pkg.pkg_name)"
 128 
         "ORDER BY UPPER(pkg.pkg_name)"
129 
      Else
 129 
      Else
130 
         ' simply find all packages matching wildcard, regardless of the specified release or any other constraint
 130 
         ' simply find all packages matching wildcard, regardless of the specified release or any other constraint
131 
         ' This is needed when user is adding package versions to a release.
 131 
         ' This is needed when user is adding package versions to a release.
- 
 
 132 
         ' Only allow the addition of package names that have versions
132 
         Search_For_Package_Names = _
 133 
         Search_For_Package_Names = _
133 
         " SELECT pkg.*"&_
 134 
         " SELECT pkg.*"&_
134 
         "  FROM packages pkg"&_
 135 
         "  FROM packages pkg"&_
135 
         " WHERE pkg.pkg_id != 0"&_
 136 
         " WHERE pkg.pkg_id != 0"&_
136 
         "   AND ( pkg.pkg_name = ''"&_
 137 
         "   AND ( pkg.pkg_name = ''"&_
137 
         SQLor &_
 138 
         SQLor &_
138 
         "       )"&_
 139 
         "       )"&_
- 
 
 140 
         "  AND  exists (select 1 from PACKAGE_VERSIONS pv where pv.PKG_ID = pkg.PKG_ID)" &_
139 
         "ORDER BY UPPER(pkg.pkg_name)"
 141 
         "ORDER BY UPPER(pkg.pkg_name)"
140 
      End If
 142 
      End If
141 
   End If
 143 
   End If
142 
 
 144 
 
143 
End Function
 145 
End Function