Qdabra qRules

Re: Using qRules "COPYTABLE" command with DBXL Query builder

Jimmy — Wed, 17 Feb 2010 17:57:40 GMT

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

Re: Using qRules "COPYTABLE" command with DBXL Query builder

SamCamblin — Wed, 17 Feb 2010 17:35:57 GMT

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...

Re: Using qRules "COPYTABLE" command with DBXL Query builder

Jimmy — Wed, 17 Feb 2010 17:06:42 GMT

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

Re: Using qRules "COPYTABLE" command with DBXL Query builder

SamCamblin — Wed, 17 Feb 2010 16:56:49 GMT

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.

Re: Using qRules "COPYTABLE" command with DBXL Query builder

Jimmy — Wed, 17 Feb 2010 16:33:48 GMT

You're missing a space before /rowsrc.

Re: Using qRules "COPYTABLE" command with DBXL Query builder

SamCamblin — Wed, 17 Feb 2010 16:20:52 GMT

I'm attaching the form...

Using qRules "COPYTABLE" command with DBXL Query builder

SamCamblin — Wed, 17 Feb 2010 16:18:50 GMT

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.