Re: Updates lost after transaction rolls back

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 09:13:08 -0500

>I start the transaction before the calling the post. I am just using a
>simple query here with data-aware controls and no batch updates at all.
>
>The transaction then rolls back, the changes to the database are lost, but
>the query has been posted and cannot be reposted. ie rolling back the
>transaction does not 'rollback' the pending updates in the query component.
>
>Hope I have explained it clearly.
You must be leaving a lot our because you message doesn't make sense.
All I can think of it that your query has locktype set to ltBatchUpdate so that
when it POSTs the data is only changed in memory.
If your Post caused ADO to write to the database and error would occur on the
POST command and it would fail leaving the user changes intact. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • RE: Combo box bound field change
    ... Modify the row source to include both fields. ... Make the bound column the company name column. ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ...
    (microsoft.public.access.forms)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • RE: Combo box bound field change
    ... You do want the companynbr field rather than the company ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ... I'd run a report to show what all that company purchased. ...
    (microsoft.public.access.forms)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... is possible for others to add other new orders to the database which I will ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • RE: Combo box bound field change
    ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ... Modify the New transaction table and change the company name field to ... I'd run a report to show what all that company purchased. ...
    (microsoft.public.access.forms)