Subversion Repositories DevTools

Rev

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

Rev 1281 Rev 3974
Line 44... Line 44...
44 
    " FROM cq_devi.admin.software_issue si LEFT OUTER JOIN"&_
 44 
    " FROM cq_devi.admin.software_issue si LEFT OUTER JOIN"&_
45 
      "    cq_devi.admin.history his ON si.dbid = his.entity_dbid"&_
 45 
      "    cq_devi.admin.history his ON si.dbid = his.entity_dbid"&_
46 
		"  WHERE si.dbid =  "& NNiss_id &_
 46 
		"  WHERE si.dbid =  "& NNiss_id &_
47 
		"  ORDER BY his.action_timestamp"
 47 
		"  ORDER BY his.action_timestamp"
48 
 
 48 
 
49 
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
 - 
 
50 
		SQLstr = _
 - 
 
51 
		" SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, his.action_timestamp AS change_stamp, his.user_name, "&_
 - 
 
52 
        "        his.action_name, his.new_state"&_
 - 
 
53 
    " FROM CQ_VT5DM.admin.software_issue si LEFT OUTER JOIN"&_
 - 
 
54 
      "    CQ_VT5DM.admin.history his ON si.dbid = his.entity_dbid"&_
 - 
 
55 
		"  WHERE si.dbid =  "& NNiss_id &_
 - 
 
56 
		"  ORDER BY his.action_timestamp"
 - 
 
57 
	End If
 - 
 
58 
 
 - 
 
59 
	OOrsCQ.ActiveConnection = CQ_conn
 49 
	OOrsCQ.ActiveConnection = CQ_conn
60 
	OOrsCQ.Source = SQLstr
 50 
	OOrsCQ.Source = SQLstr
61 
	OOrsCQ.CursorType = 0
 51 
	OOrsCQ.CursorType = 0
62 
	OOrsCQ.CursorLocation = 2
 52 
	OOrsCQ.CursorLocation = 2
63 
	OOrsCQ.LockType = 3
 53 
	OOrsCQ.LockType = 3