NOTERUN

Name

noterun

Purpose

Widget to update notes field for runstat and other databases.

Description

Read out the Notes column in a selected row of the
runstat (or other) table in any of the instrument (or other) databases.
and place in an editable scrolled text widget, saving as appropriate.
Will handle multiple rundates and databases.

Calling Sequence

noterun

Inputs

Optional Input Parameters

Keyword Input Parameters

DATABASE - Name of MYSQL instrument database for update.
The default is 'pccd2obs'. The user can specify others
via the widget File menu.
SELECTOR - Name of a column (which must be a CHAR(n) field, and unique) in the
selected database and table, used as a selector for the row
to update. The default is 'Rundate.' This is a single selector-
however, if the SELECTOR is 'Rundate' and the database table is
pccdobs.runstat the inst field must also be 'L'.
TABLE - Name of table in MYSQL database for update.
The default is 'runstat'.
XSIZE- Horizontal widget size, in characters, default is 80.
YSIZE- Vertical widget size, in lines, default is 9.

Outputs

Keyword Output Parameters

Common Blocks

Side Effects

Restrictions

Backslashes and single quotes in text are translated following
the descriptions in QUOTE and DEQUOTE.
You cannot restore a NULL to the notes field with this tool.

Procedure

Modification History

Written by Peter L. Collins, 2006/10/24, Lowell Observatory
2006/10/27, PLC, modified to save unconditionally (except Exit Without Save)
when changing data base row or exiting, to use the upgraded
QUOTE and DEQUOTE instead of runnotes, and to add the
SELECTOR keyword.