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