InfoPath Dev

Hi,

I'm trying to copy the table results from a query using DBXL Query Builder.  I'm using the below and getting an error message. 

CopyTable /dsnamesrc=GetAuditQuestions /tablesrc=/dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows/rowsrc=/row /tabledest=/my:myFields/my:group1 /rowdest=/my:group2 /empty=yes

I'm attaching a screenshot and the form. 

I'm attaching the form...

 You're missing a space before /rowsrc.

Hi Jimmy,

Thanks for your fast response.  I added a space before /rowsrc as you pointed out.  Now I'm getting the error: "Failed to select the source row to copy from." 

Here is what I currently have in my rule: 

CopyTable /dsnamesrc=GetAuditQuestions /tablesrc=/dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows /rowsrc=/row /tabledest=/my:myFields/my:group1 /rowdest=/my:group2 /empty=yes

 I'm attaching the form with the above changes for your reference.  Please help.

 There shouldn't be a slash before the field names in rowsrc and rowdest.

It works!  Thanks Jimmy. 

Its amazing I spent hours on such a simple thing.  I find I struggle with slashes and XPath stuff in qRules.  I really like your DBXL Query builder because I just select the fields, generate the query, and then copy and paste it into the form.  It makes DBXL very easy to use.  I don't know if its possible, but a tool like that for qRules would be great for technically challenged business users like me.  Just a thought...

 Glad to be of help, Sam!  And I'll be sure to pass your feedback along.