InfoPath Dev

Thanks a lot, Jimmy!

 Hi Jarecki, You can use code on the load of the form.

Submitting to SQL is a classic InfoPath problem. Here's what was discussed in an earlier thread: If you create your form using an XML Schema (File->Design...->New from Blank) you can't submit directly to a DB. That's because the schema is XML and not based off SQL data types. Submitting directly to a DB after ...

Thanks for the reply.   The problem is if I do it that way, I get: msxml5.dll Reference to undeclared namespace prefix: 'my'. I can't find a solution for that, the only way I got it to work was with the full path. Some posts said that this required a support call to Microsoft!

You need to use a relative XPath: eval(eval(group2, 'concat(my:Prompt_Other, ", ")'), "..")

OK, I did some homework. Now I realise xsi:nil means the element MUST be empty. So I've added some xslt and my code works fine now.  Here is the xslt - it adds the "my" namespace and adds xsi:nil to my two date fields if they are blank. String xsltString = @"<xsl:stylesheet ...

Hi, Has anyone tried to populate check boxes with data loaded from external data connections? I've tried to load data to drop down lists and they worked fine because by clicking on the drop down arrow, the field refreshes itself and the list is populated with the required data. However, for check boxes or option boxes, their values may be ...

Hi All - Has anyone else had this problem?   I'm populating a feld with a concatenation of data from a repreating section. The field has the default value of:eval(eval(group2, 'concat(/my:myFields/my:group1/my:group2/my:Prompt_Other, ", ")'), "..") My Data Source structure is: group1     ...

Hi all, I'm trying to populate a nested repeating table programmatically. I can populate a repeating table using the following code. However, I've been having difficulty populating the repeater nested within.  SourceFieldArray = New String() {"PROG_FORMED_MOD_COL", "MOD_COL_SHORT_NAME", "MOD_COL_NAME", ...

Thanks Jimmy!  We have streamlined the unneccessary queries to not auto-run when the form is launched but it still takes about 7-8 seconds for the form to load after loading the required data via webservice. Perhaps it's just that we have quite alot of data to retrieve and populate drop-down lists...  Anyway thanks!