Data Connections

Re: InfoPath form created from a SQL Database Datasource

m181354 — Tue, 18 Mar 2008 14:23:18 GMT

The error appears when I add a new field to the SQL table and redo my data source to pick it up. I start getting errors on form before I even attempt to add the new field to the form.

Re: InfoPath form created from a SQL Database Datasource

Greg Collins — Thu, 13 Mar 2008 17:39:24 GMT

The red dashed border is an indicator that the field value does not match the data type. For example, placing alpha text into an interger or date field.

Re: InfoPath form created from a SQL Database Datasource

m181354 — Wed, 12 Mar 2008 20:56:42 GMT

I am getting red dashed errors on fields that worked fine before I added a new column on the SQL table and re-did my Data Source. The new field shows up fine under my Data Source but I get red dash errors on the form in different places.

Is it true that it is difficult to add new fields or make updates to fields when you created the form from a Data Source(SQL Server)? Has something to do with the XML not being able to handle the changes so I was hoping there was a way to do it without using a Web Service or the Database Accelerator.

Re: InfoPath form created from a SQL Database Datasource

Greg Collins — Wed, 12 Mar 2008 17:17:51 GMT

What is the error you are getting? When does it occur? It could be that you are failing to update SQL because there are some required fields (red asterisk) that aren't filled in or because there are some field with invalid data (like a date picker with a text value -- red dashed border).

AND, if not all nodes are represented by fields are in the view, it could be coming from a node that you can't even see.

InfoPath form created from a SQL Database Datasource

m181354 — Mon, 10 Mar 2008 11:56:21 GMT

I have an InfoPath form created from a SQL Database Data source. I need to make some updates/changes to the SQL tables but when I do I get an error on the form. I re-do my data connection but I still get an error. I know I could use a Web Service or your Database Accelerator but I wanted to know if there was a way to make changes to to the SQL tables the way my form is currently setup. I am using JScript code. I have 4 views on one form. I am on an InfoPath 2003 platform.

I exported the form and made changes to my XML and XSD files. It worked but how do I save it back to my form library?

I was using the info from here...

http://msdn2.microsoft.com/en-us/library/aa202749(office.11,printer).aspx