Re: Can I used qRules to SubmitToDbxl, retrieve the SQL table record identity value (auto-numbered ID), and then write the form data along with the identity value with SubmitToSharePointList?

ErnestoM — Fri, 03 Aug 2012 13:19:14 GMT

Hi-

This tutorial doesn't use SubmitToDbxl, but it allows to submit and then immediately obtain the DocID.

http://www.infopathdev.com/files/folders/other_subjects/entry69310.aspx

The steps use QueryDocumentNodeSet to obtain the DocID, but similar steps would be used to call QueryDB instead and obtain a value from the database.

Hope this helps!

Can I used qRules to SubmitToDbxl, retrieve the SQL table record identity value (auto-numbered ID), and then write the form data along with the identity value with SubmitToSharePointList?

DC Forms — Thu, 02 Aug 2012 20:52:49 GMT

Background: The project I am working on will be using InfoPath forms to allow users to enter data into forms which will submit data to a SQL Server database for reporting purposes and simultaneously submit the same data to SharePoint lists to make use of SharePoint features such as generating MS Word documents, search, version control, etc. The database and lists are for the exclusive use of this project.

For the purposes of data integrity I would like SQL Server to generate the record identity values when InfoPath submits the data via DBXL to a SQL Server database. However, I also need to write the form data to a SharePoint list along with the identity value with the form submission. Can I used qRules to SubmitToDbxl, retrieve the SQL table record identity value (auto-numbered ID), and then write the form data along with the identity value with SubmitToSharePointList?

I’d like to SubmitToDbxl, somehow query the database for the identity value, then SubmitToSharePointList. This is because I have a workflow on the SharePoint list that takes the record entry and generates a MS Word document that includes the identity value (ID) along with the other information.

Regards,

Darian.

Qdabra qRules

Re: Can I used qRules to SubmitToDbxl, retrieve the SQL table record identity value (auto-numbered ID), and then write the form data along with the identity value with SubmitToSharePointList?

Can I used qRules to SubmitToDbxl, retrieve the SQL table record identity value (auto-numbered ID), and then write the form data along with the identity value with SubmitToSharePointList?