Ths Home Administration

• Administration Login Log Off

  This panel has multiple purposes:
  NOTE: For all purposes the Name must exist in the Valid User List.

• • Actions:    Login Admin Users List and Admin Buttons View Messages Documents System Database Statistics New User Change User Password Delete User
  • Name: 
  • Password: 
  • New Name: 
  • New Password: 
  • New Password verify: 
  • Name to Delete: 
  • Send Cancel

Editing:         Expires:  

Database Schemas holds the available database schema to be used. Pressing a drop down schema in the Database Schemas list will insert that schema name into the Database Schema field. This also fills the Schema Tables list with the tables for the schema.

Schema Tables holds the available database table for the schema that is to be used. Pressing a drop down table in the Schema Tables list will insert that table name into the Database Table field. This also fills the Table Elements list with table elements for the schema and table.

Database Select holds the selection elements between SELECT and FROM. Pressing a drop down element in Table Elements will insert it into the Database Select field with appropriate comma separators.

Database Where holds the other optional SQL clauses after the database name database name "thshome_...". You must supply the full clause. EG: "WHERE result = 'failure'".

The Build SQL button will create the SQL statement and place it into the Database SQL field for your inspection. Note that SELECT, FROM thshome_... and a trailing semi-colon will be supplied by the build operation. The Execute button will execute the SQL statement.

Statistics Select holds the selection elements between SELECT and FROM. Pressing a drop down element in Statistics Record Elements will insert it into the Statistics Select field with appropriate comma separators.

Statistics Where holds the other optional SQL clauses after the database name "statistics". You must supply the full clause. EG: "WHERE result = 'failure'".

Pressing a drop down element in Statistics Record Actions will insert that action name into the system clipboard for your convenience.

The Build SQL button will create the SQL statement and place it into the Statistics SQL field for your inspection. Note that SELECT, FROM statistics and a trailing semi-colon will be supplied by the build operation. The Execute button will execute the SQL statement.