主题：[求助]如何判断产品是否存在另一个表的多值字段里

这里都不涉及到数据源，用这个方法，找出出错的代码行：

http://www.foxtable.com/help/topics/1485.htm

然后根据错误提示分析原因。

最后实在搞不定，再贴出代码，告诉大家哪一行有错，错误提示是什么。

这样就不出错了：

Select Case e.DataCol.Name
    Case "购买座位号"
        Dim ov As String
        Dim nv As String
        If e.NewValue > "" Then
            nv = "'" & e.NewValue.REplace(",","','") & "'"
        End If
        If e.oldValue > "" Then
            nv = "'" & e.oldValue.Replace(",","','") & "'"
        End If
        If ov > "" Then
            Dim drs As List(Of DataRow) = DataTables("表A").Select("座位号 In (" & ov & ")")
            If drs.Count>0 Then
                For Each dr As DataRow In drs
                    dr("是否出售") = "否"
                Next
            End If
        End If
        If nv > "" Then
            Dim drs As List(Of DataRow) = DataTables("表A").Select("座位号 In (" & nv & ")")
            If drs.Count>0 Then
                For Each dr As DataRow In drs
                    dr("是否出售") = "是"
                Next
            End If
        End If
End Select