Updates lost after transaction rolls back

From: Matthew Pascoe (mpascoe_at_stocklogix.com.au)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 19:01:54 +1000

I am using SQL Server 2000, D5 and ADO. I have a form where the user
adds/edits data using an ADO Query.

When the user hits save, i start a transaction, post the query and do some
other updates.

If this fails, i check for a deadlock and if a deadlock did occur i try and
save again. However, the ADO Query was posted in the first attempt to save
and the changes made by the user seem to be lost in the second attempt at
saving.

Is there anyway to overcome this problem?

Thanks for any advice.

Matthew