DataViewRowState returning bogus value ??

24 Mar 2006 7:25 PM

glenn

In an attempt to update an Access database, I have DataViewRowState returning
a value of 28 which is not in the properies list of values.

Here is a code snippet:
        Dim cmdUpdate As System.Data.OleDb.OleDbCommand =
CreateUpdateCommand()

        Dim row As System.Data.DataRow
        Dim intRowsAffected As Integer
        Dim dvrs As System.Data.DataViewRowState
        dvrs = System.Data.DataViewRowState.ModifiedCurrent Or
System.Data.DataViewRowState.Deleted Or System.Data.DataViewRowState.Added
        msgbox(dvrs)
        For Each row In tbl.Select ("", "", dvrs)
        msgbox("in the for loop")

I never make it inside the For loop...

24 Mar 2006 9:26 PM

Stephany Young

Then there are obviously no rows that match the RowState specification.

Show quote

"glenn" <gl***@discussions.microsoft.com> wrote in message
news:AC6BD341-262D-449E-92BF-1F7E1C3A5880@microsoft.com...
> In an attempt to update an Access database, I have DataViewRowState
> returning
> a value of 28 which is not in the properies list of values.
>
> Here is a code snippet:
>        Dim cmdUpdate As System.Data.OleDb.OleDbCommand =
> CreateUpdateCommand()
>
>        Dim row As System.Data.DataRow
>        Dim intRowsAffected As Integer
>        Dim dvrs As System.Data.DataViewRowState
>        dvrs = System.Data.DataViewRowState.ModifiedCurrent Or
> System.Data.DataViewRowState.Deleted Or System.Data.DataViewRowState.Added
>        msgbox(dvrs)
>        For Each row In tbl.Select ("", "", dvrs)
>        msgbox("in the for loop")
>
> I never make it inside the For loop...