InfoPath Dev

can't believe I didn't see it! thanks a million jimmy!!! :D

this help?

XML file as requested

attached is the XML file, on the detail view is a table labled rev rec detail. that is the data being transformed into the main DS. I've also provided the xsn with the xslt as a resource file.

Normally I would agree, but I haven't made any changes since it was last working Saturday. It's acting as if something in the MDS is not mapping correctly but for the life of me I can't find it. Can you take a look if I provide the form? I need to have it before 9am tomorrow, should I just contact qdabra support?

Hi All. I have a form that was working as of Saturday, but now the transform piece fails with this error: "An error occurred setting the result of the transform. Schema validation found non-data type errors." Any thoughts?

My Apologies for not posting back sooner. The problem was rectified with the normalize-space() command. Although, I must add that adding it to the insert statement did decrease performance, so I applied to the field before the insert was invoked. Thanks again for your help on this, everyone.

Hi Jimmy and Hilary. It's always a pleasure to see you both. Hope your doing well. I have confirmed that running the SQL statement themselves in SQL as they were generated in InfoPath, runs in SQL perfectly and inserts all rows of data. Jimmy to address your concerns if the SQL field doesn't allow for such, it will just truncate that line ...

Any luck thus far? :)

Attached is the xsn. The button with the command is on the "View Changes" view and is called "Insert into ***" where it sets the submit_prd field to true, then that field runs the command for the RG contained in PRD. I ask that you remove the attachment or delete my reply if need be so that no one else can see it. The XML file ...