809
社区成员
发帖
与我相关
我的任务
分享activereport可以同时使用两个recordset吗？
我想打印的内容如下
field1 field2 field3
rs1.a rs2.b rs1.a-rs2.b
field1 field2 field3
rs1.a rs2.b rs1.a-rs2.b
...全文
请发表友善的回复…
发表回复
axer 2003-08-13
- 打赏
- 举报
连接两个表
axer 2003-08-13
- 打赏
- 举报
join
鲁班大叔 2003-07-01
- 打赏
- 举报
up
鲁班大叔 2003-07-01
- 打赏
- 举报
我是用代码为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"
rs3.Open sql3
ativereport1.DataControl1.Recordset = rs3
结果显示对象名rs1无效
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无效
szj820 2003-07-01
- 打赏
- 举报
ativereport1.DataControl1.source="select rs1.a,rs2.b,rs1.a-rs2.b as c from rs1,rs2"
szj820 2003-07-01
- 打赏
- 举报
用SQL结构查询
