<i><font color="#663300">I'm currently developing an application that connects to a MS SQL Server 7.0 database. Everything seems to be working fine except when I try to share connections. I have a form with inventory items and a form listing all the units of measure. Whenever I have the Item form open and try to open my Units of Measure form, I encounter the following error:
Error #: 1542
Message: Base table fields have been changed and no longer match view fields. View field properties cannot be set.
Line #: 835
Code: DataEnvironment::OpenTables()
Method: opentables
Object: frmumlist.boUMList.oDELoader
frmUMList is OK if I don't have my Item form open. The Units of Measure view has ShareConnection set to .T.
Has anyone ever encounter the same problem? I want to share connections among the application's views to minimize server load. As it is, if I don't share any connections, I get so many open connections with just one workstation running the application. Any comments/suggestions are greatly appreciated.
Thanks,
jun</font></i>
Juan,
I had this happen to me with local views long ago. It had to see with character fields where I did select a TRIM( cfield) instead of a fixed length field. And the view was complaining from time to time.
Hope this helps.
Jose
Jose Constant
Constant Software Systems
Belgium
<a href=http://www.constant.be/css target=_blank>Jose's Web Site</a>
©2002 Jose Constant |
