InfoPath Dev

I also require new versions of the form to be stored in a new row in my SQL. Right now, as I increase the form's version no. by opening the form from DAT->Documents and altering the form, my SQL no. of rows remained the same. My alteration was update to the database as an update rather than an insertion of a new row with identical formID ...

Hi,  I have got my form set up and submitted to DBXL and then to my SQL server. The form on user submit first sends an email to the recipent using InfoPath's submit as an email message data connection before getting committed to DBXL using DBXL web service document submit. The recipent then looks at the form from the email before ...

Hi Hilary,  Thanks, we will find a workaround for this.

Hi Hilary, I do not need to resubmit the existing data to its source. What I'm doing is actually to draw data from SQL to my repeating table -> Update existing value or insert/delete new rows BUT no need for updates on source as my users are supposed to use another system to do this update. However, currently when I draw data from SQL, ...

Hi it's me again... I have some repeating tables in my form which I use to hold billing dates and amounts. The objective is to store these data into another database table which is linked to my form master table. I suppose the right way is to use a foreign key to link my two tables? Using this concept, I also mapped my form data to database ...

Hi Hilary, End up, I still need to copy my repeating table data (from data source) to another repeating table on my form. These data (say billing accounts history with Bill date and Amt) is drawn from my database and can be binded into a repeating table as you mentioned above. However, I would need this table to be ...

Thanks again! It worked! But I put the catch line just before the delete line, I suppose the catch line was set to "start up" the data source so that it won't be null? Regarding the re-query, I used by original buttons. Just that the rules went: 1) Query Data connection 2) Insert search query 3) Query Data connection. Previously, I ...

Hi Potemkine, You mean place the try catch code in the reset button code or in the Query button code (the query button which did not work after the reset). My form has a rest button as well as several Query buttons in the form where users can click to query our database based on certain inputs in the form. My aim is to have a form where users ...

Hi, This worked fine for the first time only. After which, if I try to reset again, I get a System.NullReferenceException error. I tried doing checks for nulls using: XPathNavigator test = Me.DataSources["DATACONNECTION"].CreateNavigator(); If test.SelectSingleNode("dfs:myFields", Me.NamespaceManager).Value Is DBNull.Value ...

  Hi Potemkine, Now I need to go one better. Remember previously I wanted to reset all field values from my form via a button? That was settled. Now I want to reset even the secondary data connections. Can I use some code (Visual Basic) to clear my specific data connections? My form has some search function whicn populates a listbox with ...