Code

Re: Code for "Delete & Submit" (Infopath 2003)

Winney — Sun, 02 Aug 2009 02:13:49 GMT

Thanks so much! This was giving me a lot of headaches!

Re: Code for "Delete & Submit" (Infopath 2003)

Jimmy — Sat, 01 Aug 2009 00:38:08 GMT

I see. Yes, I just tried this and got the same results. It seems this is happening because InfoPath sends the command

set implicit_transactions on

before your query. Then the DELETE is considered an implicit transaction, and InfoPath sends the command:

IF @@TRANCOUNT > 0 ROLLBACK TRAN

Which rolls back your command.

I've found that you can get around this by turning implicit_transactions off, so please try this:

XDocument.QueryAdapter.Command = "set implicit_transactions off delete dbo.Table where valueId = 5; ";

Re: Code for "Delete & Submit" (Infopath 2003)

Winney — Fri, 31 Jul 2009 21:00:32 GMT

No error message, it just wouldn't delete the row in the DB.

I believe it's because I did not set the user to OWNER. However, that doesn't make sense, because I was still able to delete with the DELETE & SUBMIT action.

Re: Code for "Delete & Submit" (Infopath 2003)

Jimmy — Fri, 31 Jul 2009 14:49:01 GMT

What do you mean by "it didn't work?" Did you get an error message? If so, what?

Code for "Delete & Submit" (Infopath 2003)

Winney — Fri, 31 Jul 2009 13:37:34 GMT

I'm currently using Infopath 2003 and I haven't been able to find code for this action.

I'm using JScript and have tried:

XDocument.QueryAdapter.Command = "delete dbo.Table where valueId = 5; ";
XDocument.Query();

I've also tried a Stored Procedure and it didn't work. Yet when I used the normal Delete & Submit action, it did work. So I was hoping to run that action in the Jscript.

Thanks,