Using qRules "COPYTABLE" command with DBXL Query builder - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Using qRules "COPYTABLE" command with DBXL Query builder

Last post 02-17-2010 09:57 AM by Jimmy. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 02-17-2010 08:18 AM

    Using qRules "COPYTABLE" command with DBXL Query builder

    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. 


  • 02-17-2010 08:20 AM In reply to

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

    I'm attaching the form...

  • 02-17-2010 08:33 AM In reply to

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

     You're missing a space before /rowsrc.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 02-17-2010 08:56 AM In reply to

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

    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.

  • 02-17-2010 09:06 AM In reply to

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

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

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 02-17-2010 09:35 AM In reply to

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

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

  • 02-17-2010 09:57 AM In reply to

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

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

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.