Fitch & Mather Stocks 2000:

Service Pack 2 (SP2)

Vertigo Software, Inc.

February 2001

Summary: This article describes what changed from FMStocks 2000 SP1 to FMStocks 2000 SP2 (Build 2000.0.2). FMStocks 2000 SP2 includes bug fixes and a number of changes to improve error and transaction handling.

By installing the application, and studying the included source code, this document, and the base FMStocks 2000 design documents; you can learn how to use the Windows DNA platform to create better distributed Web-based applications.

Database

No Changes.

Setup

Schema.sql and CreateAccounts.sql now have SET QUOTED_IDENTIFIER OFF to prevent script errors when executed from the Query Analyzer in SQL Server 2000.

“Test FMStocks installation.vbs” was changed to match the new behavior of the Create New Account function and correct some syntax errors.

Website

Version information

The version in all components and projects has been updated to FMStocks Version 2000 SP2 (February 21, 2001) from FMStocks Version 2000 Update 1 (April 7, 2000).

Default.asp

Initial login account now randomly defaults to “ta1” to “ta1000” to avoid excessive stress on any one account.

ChartPortfolio.asp

The page now handle charting the portfolio of a user without any holdings correctly.

_NewAccount.asp

The page was changed to handle the new behavior of the FMStocks_Bus.Account.Add function.

Closed security hole

The Run SQL option (_runsql.asp) is now disabled by default. This option is meant as a testing tool only and should not be enabled on a server with important data. However, the user can enable it by following the instructions in the current Run SQL option.

For the same reason, the display of the database connection string is removed from the Version option (_version.asp). The user can also enable it by following the instructions there.

Components

Transactions

Data modifying classes are now marked as requiring transactions. They are:

• FMSStocks_Bus.Account
• FMStocks_DB.Tx
• FMSStore_Bus.ShoppingCart

Improved transaction handling for:

• FMStocks_Bus.Broker.BuyStock
• FMStocks_Bus.Broker.SellStock

Removed unused files

Removed the following project files:

• source\fmstocks_db\context.bas

Removed the following projects:

• FMStocks_Events
• FMStocks_EvtSub_Relay
• FMSStore_EvtSub_Relay

Synchronize versions

The following files have been updated to version 2000.0.2:

• FMStocks_Bus.dll
• FMStocks_DB.dll
• FMSStore_Bus.dll
• FMSStore_DB.dll

Modify FMStocks_Bus.Account.Add behavior

FMStocks_Bus.Account.Add no longer raises a database error when trying to add an existing account. Instead, the returning AccountID will be zero. Changes in “Test FMStocks installation.vbs” and “_NewAccount.asp” were made to match the new behavior.

Modify raise error function

Changed calls to RaiseError_DisableCommit function to calls to RaiseError. Ensure that transaction processing is handled in a consistent manner so that transactional errors can be correctly interpreted.

Modify the use of IsMissing()

The incorrect use of IsMissing() is fixed. The function was used through the DB layer to test a non-variant variable. Since the variable is always a string, we will just compare it against an empty string instead.

Other changes

· Corrected various typographical errors.

· Recompiled all components with the compiler flag “Favor Pentium Pro” enabled.