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

Record Schema Values & 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

Global Variables

Preferences

Master Settings

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

CONDENSE

CREATE FAMILY

DELETE FAMILY

DELETE MEMBER

PLIST

PREAD

PROCEDURE command

PWRITE

RENAME

 

5 Concurrency

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