Environment		Table of Contents

1 Introduction
2 Menus	New Open Save and Restore Session Clear Output Save Output As Find Select All Print Output DBMS Command Exit Spreadsheet Forms SIR File Dump Select Records Select Cases Select Records File Input List File Select Variables Output Procedures Procedure Path Procedure Path Procedure New Local Procedure Select Function Procedure Select Value Procedure Select Variable Save and Reload Program Members Member Types Search Procfile Print Member Procedure Read Procedure Write PList Member Member Name Family Name Files Dialog Painter PQLForms Painter Database Connection Export Subset Unload Journal Upload Journal Restore Download Journal Verify Database Itemise File Reload Database Import Database Delete Database Database Settings Database Security Common Variables Temporary Variables Record Schema Record Schema Definition Record Schema Common Record Schema Copy Variables Record Schema Variables Record Schema Values & Labels Database Secondary Indexes Import records from ODBC ODBC Data Source List Write Schema List Stats List Tabfiles Tabfile Information Table Information Variable labels and ranges Disconnect Tabfile Default Tabfile View Tabfile Table Details Index Details Create Index Delete Tabfile Connect Tabfile Create Table Verify Tabfile Run SIRSQL File Attributes Buffers Global Variables Master Settings Master Administration Preferences Execution Window Keymap LIST REMARKS/LIST COMMANDS SIR HELP Welcome to SIR
3 Using the Dialog & PQLForms Painters	DIALOG PAINTER Control Properties List View Dialog Properties Dialog Painter Format Multipage Dialogs PQLFORMS PAINTER Field Properties Field Sequence Screen Properties Form Properties
4 Commands	Comments and Remarks Global Variables GLOBAL GCOMPUTE System Globals Parameter Substitution INCLUDE BUFFER | FILE | MEMBER FINISH PEND DO REPEAT CIF CIF FALSE | TRUE | TF CIF END Input Flow Control IFCOND EJECT ERROR LIMIT PRINT BACK SPACE STRING LENGTH WARNING LIMIT Commands ATTRIBUTE COPY DIFFERENCE FILE MENU PAGESIZE PRINT FILE RUN MEMBER RUN NAME SCREEN OFF SET SHUTDOWN MASTER TASK NAME Procedure File Commands Procedure References CONDENSE CREATE FAMILY DELETE FAMILY DELETE MEMBER PLIST PREAD PROCEDURE command PWRITE RENAME
5 Concurrency	Running Master Record Locking
6 Compatibility	Key Mapping Colours SIR2002 Editor WDL
7 ODBC	SirSQL Server
8 Appendix	Error Messages SIR2002 Files sir.ini or .sir initialisation file Running in Batch Login Procedures Execution Parameters