# 请问使用RDC和RDO做一对多的资料时

Posted by ying on September 29, 1998 at 16:58:10:

请问小吴先生:
我如果用RDO和MSRDC做一对多的资料表,如果我表身需要另一个table 资料时,而我又希望MSRDC 在insert 和update时只能针对某一table,请问我该如何做呢?

Set rdoConn = rdoEngine.rdoEnvironments(0).OpenConnection("", rdDriverNoPrompt, False, strConnect)
strSQL = "select * from salprodm "
Set Rssalprodm = rdoConn.OpenResultset(strSQL, rdOpenDynamic, rdConcurValues)
Call DisplayRecord
'使方格的内容(订货)和(客户)资料保持同步
Call RS_MSRDC2

Private Sub RS_MSRDC2()
On Error Resume Next
MSRDC2.SQL = "select * from salprodd a,product b WHERE a.prod_no = b.prod_no and a.sale_no = '" & Rssalprodm("sale_no") & "'" & "order by a.sno asc"
MSRDC2.Refresh
End Sub

Follow Ups:

- 看不太懂耶! 小吴 08:32:02 9/30/98 (5)
  - Re: 看不太懂耶! ying 15:01:17 9/30/98 (4)
    - 希望渺茫 小吴 17:48:13 9/30/98 (3)
      - 其实还是有希望的 Kent 22:11:28 10/02/98 (2)
        - Re: 其实还是有希望的 ying 11:25:02 10/07/98 (1)
          - Re: 其实还是有希望的 kent 22:05:26 10/07/98 (0)