两个adoquery如何实现关联?
活力华华哥 2003-09-25 10:40:35 query1.sql:
select c.id,c.name as name ,p.name as teacher
from course c left join person p on c.teacher=p.id
where c.state='0'
query2.sql:
select p.id,p.name,d.name as depart
from training_plan t,person p, department d
where t.course=:id //id应为query1中course 的id
and t.person=p.id
and p.department=d.id
order by d.id
当query1 的dbgrid变动时query2的dbgrid的内容随之改变
我现在的问题是:query1有显示数据,而query2的dbgrid 没有数据,问该如何设置?