InfoPath Dev

Hello! I am new to Infopath and had a question about deleting records on my form. I am receiving/submitting data from a SQL Server DB via a webservice. I have two tables, one being nested within the other (e.g. order and order details). When I delete an order without first deleting the order details, I get an error. I added a cascade delete to my tables, however, I am still receiving the following error:

The SOAP response indicates that an error occurred on the server:
Server was unable to process request. --> Concurrency violation: the DeleteCommand affected 0 records

I imagine this to be a common scenario, however, I could not find any related posts. Can anyone provide any suggestions?

Thanks a lot,
Michele

Have not run into that problem before, although it seems to be an error with your web service. I threw this into google and found several hits regarding this issue. http://groups.google.com/groups?q=Concurrency+violation%3A+the+DeleteCommand+affected+&hl=en

Thanks vt_asparagus! I appreciate your help. You were right, it was a problem with my web service. I ended up finding a little code snippet that helped me solve my issue. If anyone is interested, take a look at the link below:

http://www.pcreview.co.uk/forums/thread-1209366.php