Home Starting Environment DBMS VisualPQL Procedures SQL Forms Host/API Index Environment 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 & Data Entry SIR File Dump Select Records Select Cases Select Records File Input List File Select Variables Output Procedures More Procedures Save and Reload Program Members Member Types Search Members Print Member Import Members Export Members Member Name Family Name Compare Procfiles Files Dialog Painter PQLForms Painter PQL Debugger Database Connection Export 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 DATA FILES Record Schema Record Schema Definition Record Schema Variables Import Value Labels Database Secondary Indexes Import records from ODBC Write Schema List Stats Control Tabfiles Tabfile Information Table Information Variable labels and ranges Disconnect Tabfile Default Tabfile View Tabfile Table Details Index Details Create Index Connect Tabfile Create Table Verify Tabfile Run SIRSQL File Attributes Buffers Preferences LIST REMARKS/LIST COMMANDS SIR/XS HELP Welcome to SIR/XS
3 Using the Dialog & PQLForms Painters	DIALOG PAINTER Control Properties List View Dialog Properties Dialog Painter Format Multipage Dialogs PQLFORMS PAINTER Field Properties Button 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 PAGESIZE PRINT FILE RUN MEMBER RUN NAME SET CLEAR SHUTDOWN MASTER TASK NAME Procedure File Commands Member References CREATE PROCFILE CONDENSE CREATE FAMILY DELETE FAMILY DELETE MEMBER PLIST PREAD PROCEDURE command PWRITE RENAME
5 Concurrency	Running Master Record Locking
6 ODBC	SirSQL Server
7 PQLServer	Client Functions when using PQLServer Running the PQLServer
8 Appendix	Error Messages SIR/XS Files sir.ini or .sir initialisation file Running in Batch Login Procedures Execution Parameters Running from a web server