Cathi,
>I am creating an application where the entire data tables need to be stored in SQL Server 7.0. In reading the documentation, the Error Handler tables is stated to be located in the main Application directory. I am confused at what this means because in a client-server environment the EXE is located on the workstation but the data is located on the network. Where is the error table supposed to be located? In addition, is there any problem with using SQL-Server to store the error handler table and access it through a remote view?>
You can locate the table anywhere you want...however, in a client-server system, you can still have a mix of both VFP and SQL Server tables...all tables do not necessarily need to be SQL Server. I prefer to leave the error log a VFP table since it's always accessible, even if my application is having problems connecting to remote data.
That said, you can definitely change Error Manager to use a remote view and corresponding SQL Server table instead. Simply open the Error Manager, right-click on the contained business object and select Builder from the shortcut menu. Although CErrorMgr is a Framework class, its data environment is not...it's called EventLogEnvironment and by default is stored in ADataEnv.vcx.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com