Qdabra Database Accelerator

Re: Problem with data posting in SQL detail table

imstac — Wed, 13 Jan 2010 20:44:46 GMT

Yea..that worked! Thanks for your help guys!

Re: Problem with data posting in SQL detail table

ErnestoM — Wed, 13 Jan 2010 20:39:54 GMT

The node path to the child table is currently blank, and that is causing the problem. That node path must the set to the repeating field in the form (my:items, probably), then the rows under that table must use a relative path to that table. Try that and let us know.

Re: Problem with data posting in SQL detail table

Hilary Stoupa — Wed, 13 Jan 2010 20:38:19 GMT

You'll want to select the my:item group for the node path for your child table, ExpenseReportItems. Then, the node paths for the mapped fields in the child table will change, so reslect those to update them.

Re: Problem with data posting in SQL detail table

imstac — Wed, 13 Jan 2010 20:31:54 GMT

Just adding a screenshot of my mappings.

Re: Problem with data posting in SQL detail table

ErnestoM — Wed, 13 Jan 2010 20:29:27 GMT

I'm sorry you're having issues with DBXL. I think a screenshot would help (you can attach one in the Options tab when you reply), since the error indicates that there might be a problem with the Child table root node.

I do have a related blog entry which may help you. Click here to read it.

Re: Problem with data posting in SQL detail table

Hilary Stoupa — Wed, 13 Jan 2010 20:26:08 GMT

Did you map your repeating group (probably my:item) to the child table? Can you attach a screen shot of your mapping (in your reply, under the options tab, there is a place to attach a file...)

Problem with data posting in SQL detail table

imstac — Wed, 13 Jan 2010 20:17:56 GMT

I am new to Qdabra and I am testing out the SQL mapping functionality. I am using the Expense Report form sample. I have two SQL tables; the parent table and then a details table (for the itemized expenses). When I just map the parent SQL table in Qdabra I have no problems with the data posting to my table; however after I add the details table mappings and click Reshred All Documents I get an error message. I'm not sure what I'm doing wrong. The error states "Problem resolving XPath: on ExpenseReportsItems object. Expression must evaluate a node-set"

My parent table has fields: id(key field, Identity is set to No), purpose and name. My details table has fields: docid (which is the link to the parent table), itemid(key field, Identity = Yes), itemamt, itemcategory, itemdate, itemdesc.

Mappings are as follows:

Parent table:

id mapped to DBXL::DocId and Key checked, name mapped to my:employee/my:name, purpose mapped to my:purpose

Child (details table):

docid mapped to parent id, itemamt mapped to my:expenseReport/my:items/my:item/my:amount, itemcategory mapped to my:expenseReport/my:items/my:item/my:category, itemdate mapped to my:expenseReport/my:items/my:item/my:date, itemdesc mapped to my:expenseReport/my:items/my:item/my:description

Is there something I'm missing?