Re: How to read the DOM

Patrick Halstead — Sun, 15 Nov 2009 12:07:40 GMT

Hi again,

Save yourself loads of time and just install Qdabra's web service which maps your XML to SQL and lets you do all of your requirements without any code. If you absolutely need Access, set up a job to copy the data from SQL to Access. Send Qdabra.com e-mail if you have questions and someone will respond. Guaranteed you can have this scenario working in an hour or two with the free trial version.

How to read the DOM

wc19380 — Tue, 10 Nov 2009 19:49:27 GMT

Hello, I am trying to write a copy function for InfoPath Document connected to an ACCESS2007 DB. The Document contains two main tables with 4 repeating tables connected. In all there are approximately 80 collumns in this document. If a user clicked on my custom "Copy Button", I would like to perform the below functionality. 1.) Save the XML data to a temp environment. 2.) Initialize the document with the same functionality as the "Add New" Button. Clear all data and set the primary keys for the each of the tables in the document. 3.) Read the XML data and post back all the columns EXCEPT the key columns(we always end the column name with "ID") I was able to read each column individually, but that can get tedious when have over 80 columns, not to mention a maintenance nightmare if the document gets new columns in the future. Any help would be greatly appreciated. Regards, Tom z...

Controls

Re: How to read the DOM

How to read the DOM