Qdabra qRules

Re: SUBMITTODBXL Error

SamCamblin — Fri, 19 Feb 2010 14:33:22 GMT

Thanks Ernesto! It worked! For anyone who doesn't know, the "Codeless Submit to DBXL" document walks you through the steps: http://www.infopathdev.com/files/folders/miscellaneous/entry35628.aspx . Thanks again.

Re: SUBMITTODBXL Error

ErnestoM — Thu, 18 Feb 2010 21:40:39 GMT

The data connection needs to be receive-type and not submit-type.

Re: SUBMITTODBXL Error

SamCamblin — Thu, 18 Feb 2010 20:58:15 GMT

Hi Ernesto,

Thanks for your fast response! For the command I'm using: concat("SubmitToDbxl /submit=SubmitDocument /name=", DocID, " /author=", userName(), " /desc=", AuditID). I verify the formula and its saying its correct (see screenshot).

I have a data connection to submit using DBXL. I even renamed it to SubmitDocument just to be sure, but its still not working. I'm assuming I have to leave the parameter elements empty in the wizard (except the XML parameter) since I'm using the qRule to define them? Is this correct?

Re: SUBMITTODBXL Error

ErnestoM — Thu, 18 Feb 2010 19:52:16 GMT

Hi Sam,

The error seems to indicate that there is no data connection called SubmitDocument. Can you check that it exists in Tools > Data Connections?

Also, what command are you using? (i.e. the command in the rule)

Thanks.

SUBMITTODBXL Error

SamCamblin — Thu, 18 Feb 2010 19:43:42 GMT

Hi,

I want to use your SubmitToDBXL qRule in my form. I've added the rule to a button. When I submit the form, I get the following error message. Please advise.

Action: SubmitToDbxl
Arguments: System.Collections.Generic.Dictionary`2[System.String,System.String]
Details: An item with the following index does not exist in the collection: SubmitDocument
Stack:   at Microsoft.Office.Interop.InfoPath.SemiTrust.DataObjects.get_Item(Object varIndex)
   at Microsoft.Office.Interop.InfoPath.SemiTrust.DataObjectsCollectionWrapper.get_Item(Object varIndex)
   at Microsoft.Office.InfoPath.Internal.DataSourcesHost.get_Item(String name)
   at Qdabra.Tools.RulesLibrary.Commands.VerifyDbxlSubmitAdapterExists(String dbxlSubmitAdapterName)
   at Qdabra.Tools.RulesLibrary.Commands.SubmitToDbxl()
   at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand(Application application, XmlFormHostItem formHost, XPathNavigator commandsNavigator)