Update records gives an error after an edit

[Jeff Brown]

Does anyone else ever feel like just giving up!!!!!

When i edit a record and then update the database i get an error, although i
can add a new record completely.
The error is : An unhandled exception of type
'System.Invalid OperationExcept ion' occurred in system.data.dll
no additional info i can see

Here is the update code i am using
:
' Temporary DataSets to store the inserted or modified row.
Dim pdsInsertedRows , pdsModifiedRows As DataSet
' Set the menu items to indicate that a record is being edited.
Call EditState(cblnN otEditing)

' End editing on the current record.
Me.BindingConte xt(DsTrailers1, "equiptrailers" ).EndCurrentEdi t()

' Copy the DataSets by getting the added or modified records from the
' original bound DataSet.
pdsInsertedRows = DsTrailers1.Get Changes(DataRow State.Added)
pdsModifiedRows = DsTrailers1.Get Changes(DataRow State.Modified)

' Check to see if there is an inserted row. If there is update DataSet.
If Not pdsInsertedRows Is Nothing Then
odbdaTrailers.U pdate(pdsInsert edRows)
End If
*************** *************** *************** *
THE ERROE THORWS HERE ON THE END IF STAEMENT
' Check to see if there is a modified row. If there is update dataset
If Not pdsModifiedRows Is Nothing Then
odbdaTrailers.U pdate(pdsModifi edRows)
End If
*************** *************** *************** *

' Synchronize the database
DsTrailers1.Acc eptChanges()

[Marina]

Is there a reason you want to do the inserts and the updates completely
separately? Why bother getting the update changes and the insert changes
separately, and then updating?

If you put try/catch around the whole thing (which you should anyway, to
catch connection problems, etc), the exception object should have a more
specific message.

"Jeff Brown" <no******@thist ime.com> wrote in message
news:aj******** **********@twis ter.austin.rr.c om...

Does anyone else ever feel like just giving up!!!!!

When i edit a record and then update the database i get an error, although i can add a new record completely.
The error is : An unhandled exception of type
'System.Invalid OperationExcept ion' occurred in system.data.dll
no additional info i can see

Here is the update code i am using
:
' Temporary DataSets to store the inserted or modified row.
Dim pdsInsertedRows , pdsModifiedRows As DataSet
' Set the menu items to indicate that a record is being edited.
Call EditState(cblnN otEditing)

' End editing on the current record.
Me.BindingConte xt(DsTrailers1, "equiptrailers" ).EndCurrentEdi t()

' Copy the DataSets by getting the added or modified records from the
' original bound DataSet.
pdsInsertedRows = DsTrailers1.Get Changes(DataRow State.Added)
pdsModifiedRows = DsTrailers1.Get Changes(DataRow State.Modified)

' Check to see if there is an inserted row. If there is update DataSet.
If Not pdsInsertedRows Is Nothing Then
odbdaTrailers.U pdate(pdsInsert edRows)
End If
*************** *************** *************** *
THE ERROE THORWS HERE ON THE END IF STAEMENT
' Check to see if there is a modified row. If there is update dataset
If Not pdsModifiedRows Is Nothing Then
odbdaTrailers.U pdate(pdsModifi edRows)
End If
*************** *************** *************** *

' Synchronize the database
DsTrailers1.Acc eptChanges()

[Jeff Brown]

Will give that a try....

The insert & edit procedures i have working on the local dataset....

I figured that way changes would not be immedialtely commited and hence
prevent faulty edits.
"Marina" <nospam> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...

Is there a reason you want to do the inserts and the updates completely
separately? Why bother getting the update changes and the insert changes
separately, and then updating?

If you put try/catch around the whole thing (which you should anyway, to
catch connection problems, etc), the exception object should have a more
specific message.

"Jeff Brown" <no******@thist ime.com> wrote in message
news:aj******** **********@twis ter.austin.rr.c om...

Does anyone else ever feel like just giving up!!!!!

When i edit a record and then update the database i get an error,

although i

can add a new record completely.
The error is : An unhandled exception of type
'System.Invalid OperationExcept ion' occurred in system.data.dll
no additional info i can see

Here is the update code i am using
:
' Temporary DataSets to store the inserted or modified row.
Dim pdsInsertedRows , pdsModifiedRows As DataSet
' Set the menu items to indicate that a record is being edited.
Call EditState(cblnN otEditing)

' End editing on the current record.
Me.BindingConte xt(DsTrailers1, "equiptrailers" ).EndCurrentEdi t()

' Copy the DataSets by getting the added or modified records from the
' original bound DataSet.
pdsInsertedRows = DsTrailers1.Get Changes(DataRow State.Added)
pdsModifiedRows = DsTrailers1.Get Changes(DataRow State.Modified)

' Check to see if there is an inserted row. If there is update DataSet.
If Not pdsInsertedRows Is Nothing Then
odbdaTrailers.U pdate(pdsInsert edRows)
End If
*************** *************** *************** *
THE ERROE THORWS HERE ON THE END IF STAEMENT
' Check to see if there is a modified row. If there is update dataset
If Not pdsModifiedRows Is Nothing Then
odbdaTrailers.U pdate(pdsModifi edRows)
End If
*************** *************** *************** *

' Synchronize the database
DsTrailers1.Acc eptChanges()

[Jeff Brown]

Tried that and i get an empty message box
also tried ex as system.exceptio n and systemexception
and System.InvalidO perationExcepti on
with the same results

Try
If Not pdsModifiedRows Is Nothing Then
odbdaTrailers.U pdate(pdsModifi edRows)
End If
Catch ex As Exception
MessageBox.Show (ex.Message, "Error", MessageBoxButto ns.OK,
MessageBoxIcon. Error)End Try

"Marina" <nospam> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...

Is there a reason you want to do the inserts and the updates completely
separately? Why bother getting the update changes and the insert changes
separately, and then updating?

If you put try/catch around the whole thing (which you should anyway, to
catch connection problems, etc), the exception object should have a more
specific message.

"Jeff Brown" <no******@thist ime.com> wrote in message
news:aj******** **********@twis ter.austin.rr.c om...

Does anyone else ever feel like just giving up!!!!!

When i edit a record and then update the database i get an error,

although i

can add a new record completely.
The error is : An unhandled exception of type
'System.Invalid OperationExcept ion' occurred in system.data.dll
no additional info i can see

Here is the update code i am using
:
' Temporary DataSets to store the inserted or modified row.
Dim pdsInsertedRows , pdsModifiedRows As DataSet
' Set the menu items to indicate that a record is being edited.
Call EditState(cblnN otEditing)

' End editing on the current record.
Me.BindingConte xt(DsTrailers1, "equiptrailers" ).EndCurrentEdi t()

' Copy the DataSets by getting the added or modified records from the
' original bound DataSet.
pdsInsertedRows = DsTrailers1.Get Changes(DataRow State.Added)
pdsModifiedRows = DsTrailers1.Get Changes(DataRow State.Modified)

' Check to see if there is an inserted row. If there is update DataSet.
If Not pdsInsertedRows Is Nothing Then
odbdaTrailers.U pdate(pdsInsert edRows)
End If
*************** *************** *************** *
THE ERROE THORWS HERE ON THE END IF STAEMENT
' Check to see if there is a modified row. If there is update dataset
If Not pdsModifiedRows Is Nothing Then
odbdaTrailers.U pdate(pdsModifi edRows)
End If
*************** *************** *************** *

' Synchronize the database
DsTrailers1.Acc eptChanges()