在窗口中table1通过
Dim t As Table = e.Form.Controls("Table1").Table
Win.FoxLib.Syscmd.CreateFoxConnection("数据源")
Dim SQLText As String
SQLText = " select a.wareid as 商品编码,a.warename as 商品名称,"
SQLText += " a.warespec as 商品规格,a.producer as 生产企业, "
SQLText += " a.maxunit as 个性标识,a.prod_add as 产地, "
SQLText += " a.wareunit as 标准单位,b.purprice as 最新进价, "
SQLText += " b.saleprice as 最新售价 FRO M u_ware a (nolock), u_ware_q b (nolock)"
SQLText += " WHERE a.wareid = b.wareid"
t.Fill(SQLText,"数据源",True)
在table2中通过 SQLtable类型
select * fro m 对比分析表
他们通过wareid关联起来，该如何实现
table1为父表，table2为子表
[此贴子已经被作者于2017/5/3 15:58:40编辑过]
加好友 
发短信
Post By：2017/5/3 15:58:00 [显示全部帖子]
