Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / August 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RickH - 04 Aug 2004 05:38 GMT
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\) - 04 Aug 2004 18:30 GMT
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/

> Have a Visual Studio Project with an Infopath form based
> on a SQL DB.
[quoted text clipped - 10 lines]
> THe project is getting large, starting over each time
> takes many hours of work,,,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.