Name change on a SQL Server Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mdsmitty - 21 Sep 2005 18:02 GMT

I have several tables for some of my form solutions and in an effort to
better organize a large SQL Server DB I'd like to change the names of some of
my tables so they are listed together in the DB. I have done this with one
of my forms and it proved to be a lengthy process having to rebind every
field/control on the form. Is there a better way to do this? I am not
changing the DB, column names, or location of anything, just the table names
within the DB.

Thanks
Smitty

Reply to this Message

Franck Dauché - 21 Sep 2005 18:27 GMT

Hi,

The best would have been to use a Web Service between your DB and the IP
form. Any change within the DB or even any change of DB type would be
transparent to the form.

Franck Dauché

> I have several tables for some of my form solutions and in an effort to
> better organize a large SQL Server DB I'd like to change the names of some of
[quoted text clipped - 6 lines]
> Thanks
> Smitty

Reply to this Message

Michael K. - 22 Sep 2005 17:33 GMT

current virsions of InfoPath are not gracefull when it comes to changes is
data sources, wether it is change in location or their schema.
"When you design a form, Microsoft Office InfoPath 2003 assumes that the
form's data source is in it's final state. InfoPath doesn't adapt to changes
in the form's data source. This article discusses how to update the data
source information in your form when the source schema changes."

One dangerouse, option for you is to manualy modify componets of XSN
(manifest, schemas, xslt, template). The complexety of those modifications
could vary based on what was changed.

Reply to this Message