我在query的属性SQL中写了
SELECT STUDENT.CLASS,STUDENT.ID,STUDENT.NAME
FROM STUDENT,SCORCE
WHERE SCORE.COURSE=:COURSE
AND SCORE.STUDENT=STUDENT.ID
ORDER BY STUDENT.ID
可是用DBGRID连接时出现field 'course' is of an unknown type错误
请问错在哪
SELECT STUDENT.CLASS,STUDENT.ID,STUDENT.NAME
FROM STUDENT,SCORCE
WHERE SCORE.COURSE=:COURSE
AND SCORE.STUDENT=STUDENT.ID
ORDER BY STUDENT.ID
可是用DBGRID连接时出现field 'course' is of an unknown type错误
请问错在哪
试试看
FROM STUDENT join SCORCE on SCORE.STUDENT=STUDENT.ID
/* 表首先要进行联接 */
WHERE SCORE.COURSE=:COURSE
ORDER BY STUDENT.ID
Try it.Good Luck!^_^
连上就没什么问题了,再把参数加上,记得设计期不要激活query
http://expert.csdn.net/Expert/topic/1381/1381664.xml?temp=.9872248
可是输入后出现“数据库引擎找不到SCORE表”的错误