ativereport1.DataControl1.source="select rs1.a,rs2.b,rs1.a-rs2.b as c from rs1,rs2"
我是用代码为ar连接数据库 sql1 = "select country from test" rs1.Open sql1 sql2 = "select name from test" rs2.Open sql2 sql3 = "select rs1.country as a,rs2.name as b,rs1.counry+rs2.name as c from rs1,rs2"
sql1 = "select country from test"
rs1.Open sql1
sql2 = "select name from test"
rs2.Open sql2
sql3 = "select rs1.country as a,rs2.name as b,rs1.counry+rs2.name as c from rs1,rs2"
rs3.Open sql3
ativereport1.DataControl1.Recordset = rs3
结果显示对象名rs1无效