----------------------------------------------
For bug tracking, use Bugzero, fully supported http://www.websina.com/cn/作者: awei114 时间: 2008-2-29 19:58
Updated defects could not be read: SQLExecDirect: RETCODE=-1, State=37000, Native Error=1033 SQL statement="SELECT id, dbid, version FROM spr d WHERE td_id is null and id in (select distinct T1.id from spr T1,statedef T2,modules T3,severity T4,repeatabel T5,users T6,users T8,project T10 where T1.state = T2.id and T1.modules = T3.dbid and T1.severity = T4.dbid and T1.repeatabel = T5.dbid and T1.submitter = T6.dbid and T1.owner = T8.dbid and T1.project = T10.dbid and (T1.dbid <> 0 and (T10.project = 'D330')) order by T1.id DESC) UNION SELECT id, d.dbid, d.version FROM spr d, history h WHERE h.entity_dbid = d.dbid and h.action_timestamp > '27 Feb 2008 13:23:09' and id in (select distinct T1.id from spr T1,statedef T2,modules T3,severity T4,repeatabel T5,users T6,users T8,project T10 where T1.state = T2.id and T1.modules = T3.dbid and T1.severity = T4.dbid and T1.repeatabel = T5.dbid and T1.submitter = T6.dbid and T1.owner = T8.dbid and T1.project = T10.dbid and (T1.dbid <> 0 and (T10.project = 'D330')) order by T1.id DESC) " [Microsoft][ODBC SQL Server Driver][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
以上是我在做TD与CQ挂接时出现的问题，那位遇到过？请教了。我在另外的帖子看到过有人出现过问题，不知道你们解决了吗？：http://bbs.51testing.com/viewthread.php?tid=2608作者: awei114 时间: 2008-3-3 11:31
高人指点下阿，如果我在建立link是不指定cq的query，选择none，则可以连接正常，能够把cq中的用户都导入到TD中。但是defect无法导入到TD，TD内的也无法导入到CQ。最主要的还是如果无法选择query则就是便是一个TD项目对应一个CQ的datebase。这就太不现实了。大家都知道CQ的datebase中一般可以包括很多项目的。作者: awei114 时间: 2008-3-6 09:23
没有知道的吗？ ，
.现在我已经在CQ与TD之间通过td提供的同步插件建立link了.但是有error.:Failed to fetch list of values for ClearQuest field '璐ｄ换浜?: 绫诲瀷涓嶅尮閰?,更郁闷的就是其中的field值还是乱码.
，