InfoPath Dev

Hi, We are using Infopath 2007 and I'm having difficulty trying to code my form to run some stored procedures from my SQL server. What I have in my button code is:Dim myAdoQueryConnection As AdoQueryConnection = Me.DataConnections("DataConnection") myAdoQueryConnection.Command = "exec ...

  I'm am also having a weird output here when I use my database data connection. On preview mode, I can draw data from my database data connection based on the table it is tagged to. However once I launch my form from server (go to DBXL and use the link to open form), I can no longer draw any data from my database DC. It seems I cannot ...

Hi Hilary,  I have the same question here. When we need to have a data connection for this case, what you are saying is we can just create a Database data connection, select a database and its table and while this makes the data connection limited to the table, we can use code to run select statements to another table? I'm also have ...

Ok thanks for that.  I have removed the multi-select list from the repeating table.  Just wondering if there is now a way to promote only true values to the Sharepoint column for this list.  Thanks again.

 Hi Patrick,               I have downloaded the trial version of DBXL.Now can u help me in solving the above problem(repeating section).I couldn find any support regarding it Thank you in advance

Hi There Potemkine, Thank you for your time and effort, it is very much appreciated! The design checker at my side indicates no problems so I think you are right in the sense that the error you encountered on your side was probably data connection related. I'm sorry if I've have wasted your time  The ...

Hello Big E, How about using a repeating section within a repeating section like in the attached (very simplistic) example to keep track of versions for different files?  Using qRules, you can augment the functionality to restrict users from removing rows that are already keeping track of files.  This would save you from having to ...

Patrick. I have never had any dealings with .stp or .wsp files.  I have created my data connections on the test site.  Taken a copy, edited them, then uploaded them to me new site; into a Data Connection Library that I created myself. What do I do next?  Is there anywhere that will show me how to publish to my new site, ...

Success!! Thank you Potemkine you solved my problem you rule.

I do have two views in my Print Multiple Views (View 1 and Print Version View 1) box but neither of them are checked. Although Allow users to change these settings is checked. Should I delete the Print Version View 1?