Re: Transaction and RowState problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Try calling DataRow.RejectChanges().

--
Dave Sexton

"perspolis" <rezarms@xxxxxxxxxxx> wrote in message
news:u7j1cgc$GHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
Hi all
I have a master detail table which I use them in Transaction to Update them.
in some cases the detail table generates error and I Rollback transaction
but RowState of master table dosen't go back to previous state and no data
has entered in database yet but in my master table in memory it has data..
????
how can I change RowState of master table to previous RowState before
begining Save.

thanks in advance





.

Relevant Pages

  • Re: Update and Append Query
    ... UPDATE Master RIGHT JOIN [Transaction] ... "Tom Lake" wrote: ... One query will do both. ...
    (microsoft.public.access.queries)
  • Re: Simply adding two fields
    ... I'm reading a transaction file of widgets delivered and I want to update the ... quantity in the master record, so I do a query joining the master and ... Just redo the calculation whenever you need it, ...
    (microsoft.public.access.queries)
  • Re: Indicating Stored Procedure progress on Form
    ... connection used by Access to open the second form. ... 2- A transaction is open when the master SP is called, ... writes are then part of this transaction and won't be visible from the ... the form requeries and the completed ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Hot Backup - D3/Linux
    ... Hot backup IS transaction logger. ... You do a full restore on this backup machine. ... You define a slave master ... With reasonably fast lan speeds and reasonably fast hardware, ...
    (comp.databases.pick)
  • Re: BeginTransaction helppppppppppppppppppp?
    ... > transaction and "EndSave" method to commit transaction. ... > I wanted to know dose .Net support nested transaction?? ... saving of the detail which are locked by the master. ... which contains the connection and the Sqltransaction object. ...
    (microsoft.public.dotnet.languages.csharp)