Subversion Repositories DevTools

Rev

Rev 35 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 35 Rev 37
Line 782... Line 782...
782
 
782
 
783
      ElseIf CDbl(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
783
      ElseIf CDbl(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
784
         iss_num_col = "new_num"
784
         iss_num_col = "new_num"
785
         SSsql = _
785
         SSsql = _
786
         " SELECT si.dbid AS iss_id, si."& iss_num_col &" AS iss_num"&_
786
         " SELECT si.dbid AS iss_id, si."& iss_num_col &" AS iss_num"&_
787
         " FROM DEVI_PROD.admin.software_issue si"&_
787
         " FROM CQ_DEVI.admin.software_issue si"&_
788
         " WHERE "
788
         " WHERE "
789
 
789
 
790
 
790
 
791
      ElseIf CDbl(NNiss_db) = enumCLEARQUEST_TDSE_ID Then
791
      ElseIf CDbl(NNiss_db) = enumCLEARQUEST_TDSE_ID Then
792
         iss_num_col = "job_number"
792
         iss_num_col = "job_number"
793
         SSsql = _
793
         SSsql = _
794
         " SELECT dbid AS iss_id, si."& iss_num_col &" AS iss_num"&_
794
         " SELECT dbid AS iss_id, si."& iss_num_col &" AS iss_num"&_
795
         " FROM TDSE_2002.admin.request si"&_
795
         " FROM CQ_TDSE.admin.request si"&_
796
         " WHERE "
796
         " WHERE "
797
 
797
 
798
      End If
798
      End If
799
 
799
 
800
 
800