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
©2002 Jun M. Ramoneda |
