Haschanges / Getchanges

ViagraFalls · September 22nd, 2004, 04:55 AM

Good day,

For a few days now, I've been banging my head against my keyboard over a very weird error I'm experiencing.

The basics:

I use a 'New' button to add a row to my dataset. Looking at the database, I can see the new row added with the default value.

Next, I change one of the fields of this newly added row. Using the following code, I send the updated row to the dataset:

Code:

If DsWerkplek1.HasChanges(DataRowState.Modified) = True Then
        Try

        Dim i As Integer
        i = daWerkplek.Update(DsWerkplek1.GetChanges(DataRowState.Modified))
        MsgBox(i)
        Catch ex As Exception
        End Try

After this snippet completes, I throw a CommitChanges to the dataset.

Overall, this works just fine. However, in a very specific case, while debugging, the IF statement returns 'true', meaning the dataset
indeed DOES have changes. However, the GetChanges refuses to yeld any results whatsoever, and the exception will be fired.

I am so totally lost, and hope someone, somewhere ran into the same problem and found a solution.

:(

Thanks.

Peter