-
I don't believe this is possible in database-bound forms. You would need a regular InfoPath form (not bound to a database), which submits to the database using a web service. That way you can modify the schema as necessary. We typically use the DBXL web service, but it is not compatible with Access.
-
Hi Morten, other than writing your own custom code, the only other suggestion I have is trying out qRules (http://www.qdabra.com/en/products/qRules.aspx), and, specifically, this document (http://www.infopathdev.com/files/folders/qrules/entry49403.aspx). Good luck!
-
Hi Jonathan,
After investigating, CopyTable will not work in this scenario. We will consider this idea for a future enhancement (i.e. specifying a position parameter that allows the user to specify where they want the new table inserted).
-
You can write custom code to accomplish this, or you can use qRules (the command is called Insert).
-
Hi Jonathan,
I think we've made some progress, but I'm afraid I don't understand the current issue. You mention that no error is returned and that a copy operation is taking place. If the issue is that the operation is appending data, simply change the command to /empty=yes in order to clear the table before copying. If I ...
-
The command you want to use is called CopyTable, not Copy. Can you try using that command and let us know the result? Thanks.
-
This was solved last week. In case anyone else faces a similar issue, the problem was that Sharepoint was accessed via http://domainname.com, whereas DBXL was installed to http://<machinename>. The solution was to switch DBXL to use the fully qualified domain name as well.
-
Thanks for the screenshots. You can drag the error node into the view to temporarily debug the issue. Can you do this and let us know the error that is getting returned in that node? Thanks!
-
Hi Michelle,
You can control form upgrade options under Tools. Screenshot attached.
Hope this helps!
-
Hi Jonathan,
Could you post a screenshot of your source and destination data sources?
Thanks!