Qdabra qRules

Re: Using CopyTable with Null Values in SQL results

Hilary Stoupa — Mon, 31 Dec 2012 17:58:58 GMT

I'm glad the forum has been helpful! qRules has a bit of a learning curve, but it really can give your forms fantastic functionality w/out you having to write your own code. Let me know if putting your nodes in the same order solves the issue for you. :-)

Re: Using CopyTable with Null Values in SQL results

douglasjenn — Mon, 31 Dec 2012 17:46:54 GMT

I'll give that a shot. Not in production yet :) Thanks!

BTW...you are amazing! I have used responses on this forum to help me with this. First timers using Qrules.

Re: Using CopyTable with Null Values in SQL results

Hilary Stoupa — Mon, 31 Dec 2012 16:42:52 GMT

Looking at your first post again, now that you've posted your results - your fields in your main data source appear to be in a different order than your secondary - copy table just copies the first field in the source data source to the first field in the destination data source and so on. Is your form in production yet? If not, you might want to just rearrange your data source to match your secondary.

Re: Using CopyTable with Null Values in SQL results

douglasjenn — Mon, 31 Dec 2012 16:34:05 GMT

Here's the results I get. I'm using version 4.2. Thanks!

Re: Using CopyTable with Null Values in SQL results

Hilary Stoupa — Mon, 31 Dec 2012 16:05:34 GMT

This sounds like a bug - let me see if I can reproduce it. What version of qRules are you using?

Using CopyTable with Null Values in SQL results

douglasjenn — Mon, 31 Dec 2012 14:17:19 GMT

I have successfully used QRules to copy the results from a SQL query into a Infopath repeating table. The goal is to pull current values from one of our systems into this form and then allow the user to delete/modify those results. The issue I am having is if one of the columns of data is null it appends the data to the wrong column in the editable table (see attached for screenshot). Is there a "switch" that I need to add that will allow it to consider null values as valid values when using the Copytable function?

Here's the code I am currently using. The attached has a screenshot of the results as well as my data field structure.

To pull data from SQL table:

concat("ModifySqlQuery /dsname=CropInsuranceDatabase /where=where TblCustomer.SSN='", SNNwithdashes, "'")

To copy to editable table:

CopyTable /dsnamesrc=CropInsuranceDatabase /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=d:TblCustomer /tabledest=/my:myFields/my:TranswithAgSouthSection/my:CropInsSection /rowdest=my:CropInsSectionList /empty=yes