InfoPath Dev

Is there a way to configure your data mapping in DBXL to NOT shred data from form fields if there is no data?  We have a relationship between two tables and if there is no data the mapping is attempting to write a NULL record in one table which violates our primary index.

 Absolutely.  Just have a look at this blog:

http://www.infopathdev.com/blogs/ernesto/archive/2009/07/31/conditional-sql-mapping-with-dbxl-v2-3.aspx

Thanks!  That is exactly what I was looking for. 

FYI...

Here's a method of handling invalid numeric values in case you have form fields that are string type but need to be treated as numeric values.

my:ID[string(number(.))!='NaN']

Valid numeric values will get saved and an invalid numeric value is saved as NULL.