SP1:SQL DB table modified, best way to recover?

[RickH]

Have a Visual Studio Project with an Infopath form based
on a SQL DB.
New field got added to one of the SQL tables. I manually
edited the schema to add the field.
Infopath loads the form OK and shows the new field in the
datasource just fine.
I can add a dd listbox linked to the new field OK.
Then when I Preview the form, the control is greyed out.
What is the Best Practice to add a field to a SQL based
form in sp1?
In the non-sp1 version, editing the schema was enough for
it to work.
THe project is getting large, starting over each time
takes many hours of work,,,

 

[Matthew Blain \(Serriform\)]

SP1 has a feature to update the main data source. This is Tools : Convert
Main Data Source.
If you have edited the schema by hand, you may need add the default value.
This is in Tools : Default Values. Make sure all the boxes are checked.

--Matthew Blain
http://tips.serriform.com/