请教动态属性 unique table,Unique Catalog的用法
salan 2006-02-23 03:30:12 Dim cn As New ADODB.Connection
cn.Open "provider=sqloledb.1;data source=;initial catalog=fxsuper;user id=sa;password=;"
Dim rs As New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Properties("Unique Table").Value = "stor_tab_c"
rs.Open "select stor_tab_c.dz_no,stor_tab_c.cnt,stor_tab_c.wl_code,stor_tab_c.wl_num,stor_tab_c.hwl_num,wlt_c.prd_name from stor_tab_c inner join wlt_c on stor_tab_c.wl_code = wlt_c.prd_code where dz_no='a10066'", cn, adOpenStatic, adLockBatchOptimistic
rs.AddNew
rs(0) = "A10066"
rs(1) = 2
rs(2) = "100301"
rs(3) = 550
rs(4) = 1000
rs(5) = "平纹布"
rs.UpdateBatch
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
请问为什么指定了unique table(stor_tab_c),新增记录的时候从表(wlt_c)还是会同样新增呢?
但是我试过删除记录没有问题,只会删主表(stor_tab_c)中的记录,从表(wlt_c)不会删除.我这样用法对吗?