Adding the Settings Table

After they started coding the CML application, the developers realized the benefits of adding one more table, a table of application settings, to the database. This table replaces values coded in FmLib stored procedures and the CML application global.asa file. All application settings are now kept in one place, the settings table, and are updated from one place, the AppSettings.asp page. Administrators need not be familiar with changing SQL Server stored procedures or the global.asa file. Should additional application settings be required in the future, it is a small task to modify the ASP page and the database table. The table for CML application settings is: