Qdabra Database Accelerator

Re: DBXL XPath Expressions

Jim Cantwell — Wed, 17 Mar 2010 04:42:25 GMT

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.

Re: DBXL XPath Expressions

roswold — Wed, 17 Mar 2010 03:56:45 GMT

Thanks! That is exactly what I was looking for.

Re: DBXL XPath Expressions

Jimmy — Wed, 17 Mar 2010 03:46:03 GMT

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

DBXL XPath Expressions

roswold — Wed, 17 Mar 2010 03:36:49 GMT

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.