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. CATEGORY: Database 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.