是这样的,我要把_identify作为记录的唯一标识,我在明细表增加了一个叫ID的字段,然后在点击“审核”按钮之后,执行下面代码:Tables("采购单").Current("审核") = "已审核"
Tables("采购单").Current.Locked = True
Tables("采购单").Current.Save()
For Each cdr As DataRow In dr.DataRow.GetChildRows("采购明细")
CDR.LOCK
CDR.SAVE
cdr(“ID”)=Tables("采购明细").Current("_identify")
NEXT
然后发现ID值都是1??按照帮助的说法,_identify只有在保存之后才会生效,按道理这时候记录应该已经得到正确的ID值了啊?
然后再改下,重复循环一次吧,代码改成:
Tables("采购单").Current("审核") = "已审核"
Tables("采购单").Current.Locked = True
Tables("采购单").Current.Save()
For Each cdr As DataRow In dr.DataRow.GetChildRows("采购明细")
CDR.LOCK
CDR.SAVE
NEXT
For Each cid As DataRow In dr.DataRow.GetChildRows("采购明细")
Dim id As Integer = Tables("采购明细").Current("_identify")
cid("ID")=id
cid.save
msgbox(id)
Next
但是ID的值仍然是1???我错在哪里??