troubleshooting Question

Asynchronus function calls - I think

Avatar of NBAIS
NBAIS asked on
ASP.NETWCFMicrosoft SQL Server 2005
5 Comments1 Solution227 ViewsLast Modified:
We have a web service on a Windows 2003 server running that is running transactions against another server with SQL Server 2005 installed on it.  My problem is that I have a function that copies one record into another and then end dates the previous record.  Following this, I have a series of updates statements that run against the new copy of the record so that we have a complete history with date tracking.

The interesting part comes when the webservice runs the copy function and once it thinks it's finished it continues on to the update function.  However, the insert function isn't finished writing to the server so none of the updates are processed.  I've tried try and catch statements and in the end had to put a two second delay on my page that was calling the functions.  Is anyone else having this problem?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros