Stored procedures, which run from the PostActions method in the SQLXML component, perform all table actions (insert, update, and delete) on tables in the Eval database. In addition, the Performance Tracking (PT) application uses stored procedures to query the database. The following topics describe how the application implements stored procedures:
The following table lists the procedure names and JavaScript files that assign stored procedure names to hidden fields on forms, and describes the tasks the procedures perform. The stored procedures are grouped according to the type of action they perform: add, change, delete, or select. Click the procedure name to access the SQL script for the procedure; click the script name to access the JavaScript for the procedure; click the table name to access the SQL Server™ table definition.
The following stored procedures are coded for implementation in the PT User application and are not implemented by the PT Admin application in Scenario 3: