Sheerpower® A Guide to the Sheerpower Language

A Guide to the Sheerpower Language

Touch Technologies, Inc.
10650 Scripps Ranch Blvd. Suite 100
San Diego, CA 92131

1-800-525-2527 or 1-858-566-3603


® Windows XP, Windows Vista, Windows 7 and Windows 8 are registered trademarks of Microsoft.

® Sheerpower is a registered trademark of Touch Technologies, Inc.


Touch Technologies, Inc. (TTI) has prepared this publication for use by TTI personnel, licensees, and customers. This information is protected by copyright. No part of this document may be photocopied, reproduced or translated to another language without prior written consent of Touch Technologies, Incorporated.

TTI believes the information described in this publication is accurate and reliable; much care has been taken in its preparation. However, no responsibility, financial or otherwise, is accepted for any consequences arising out of the use of this material.

The information contained herein is subject to change without notice and should not be construed as a commitment by Touch Technologies, Inc.

Revised: April 13, 2015 for V6.0

Copyright ©2001-2015 Touch Technologies, Inc.

Contents Index


Sheerpower is a next generation database language for Windows. It works on Windows Vista, Windows 7, Windows 8 and Windows Server. It includes a Rapid Development Environment (SPDEV) and a fourth-generation Database Language (SP4GL) .

The Sheerpower language:

Sheerpower excels at both character and mathematical utility, combining them into a powerful, easy-to-use framework. Sheerpower can be used to write programs of any size, from simple-input applications to vast database infrastructures and Web applications.

Sheerpower includes a transparent interface to the ARS (Advanced Record System) database engine as well as to other database engines. (ARS is bundled into Sheerpower).

ARS is integrated into Sheerpower featuring extremely high speed sequential and random access to database information. In addition, ARS is optimized for client/server applications through the use of high performance memory resident shared data.

The interface includes:

The Sheerpower development environment is designed for developing complex applications rapidly. This interactive environment:

Development cycle time is the time it takes to edit, compile, link, run and debug code. Sheerpower reduces this time by providing an interactive and fast response environment. Sheerpower offers features that cut cycle time significantly--up to 80%.

You will find Sheerpower an exciting and powerful programming tool.

Sheerpower Reference Manuals

All Sheerpower manuals are designed to provide information in a manner that is concise and easy to use. The manuals are:

Purpose of this Guide

The purpose of this Guide is to present the information you will need to develop programs with Sheerpower. The intent is to provide you, the user, with simple and concise explanations of the Sheerpower system, features, and language. This manual is designed to provide a basic and thorough explanation of each element. This manual can also be used as a reference guide by advanced users.

Intended Audience

This Guide is written for both experienced programmers and those self-learners who have had some exposure to computers and programming languages.

User Feedback and Technical Support

Your feedback is greatly appreciated. Tell us what you think about the Sheerpower language, development environment, website, and documentation.

In addition, if you encounter any technical issues, please email them to us and we will respond within 48 hours.

Please send all feedback and technical support requests to:

Thank you for using Sheerpower.

Chapter 1
Getting Started in Sheerpower

1.1 Getting Started

Download Sheerpower

Download the latest version of Sheerpower by clicking HERE .

Click on the Download Sheerpower Full Development Environment (Less than 10 MB) link.

Follow the instructions on the download webpage to download and install Sheerpower.

How to Start the Sheerpower Rapid Development Environment

To start the Sheerpower Rapid Development Environment (SPDEV), double click the Sheerpower shortcut icon located on your desktop---a circle with a lightning bolt through it.

Below is an image of what SPDEV looks like when it is running.

1.2 Creating a New Program in Sheerpower

To create a new program in Sheerpower Rapid Development Environment, click once on the New icon in the toolbar---a white paper with one corner folded. This will create a new file for you to work in.

You can also click on File in the SPDEV toolbar and select New from the drop down menu of choices to create a new file.

The Name New File... dialog box will appear and ask you to name your new file, and to specify the location you want to save it to.

Type the name of the new program file inside the File name: field. Name this new file Menu.

The default file type to save a file is .SPSRC. It shows as "Sheerpower source files (*.spsrc)" in the "Files of type" drop down list. This creates a Sheerpower source program file. When you click on [Save] the .SPSRC file type extension will automatically be added on to the file name. Clicking on the down arrow will drop down a list of other different file types to save your files as.

With "Sheerpower source files (*.spsrc)" selected as the file type, click on [Save].

After you click on the [Save] button in the "Name New File..." dialog box, a new document window will open within SPDEV.

A dialog box will also appear prompting you for your name, company name and program name.

When you fill in this information and click on [OK], a program template will automatically be inserted into your new program file. See Appendix I, Developing Professional Applications with SheerPower for a detailed discussion on the special features built-in to Sheerpower designed to save time and money when creating professional applications.

For the purpose of this basic tutorial, click on [Cancel] to skip creating the program template.

You can now begin to write your new Sheerpower program inside the new document window.

1.2.1 Menu Program Example

Copy and paste or type the following program code into the new menu.spsrc file inside SPDEV.


The examples show how commands or statements are used. Wherever possible, the example is a full program rather than a program fragment.

You are encouraged to type in (or copy/paste) the Sheerpower examples into SPDEV throughout this manual and try running them.

Example 1-1 Menu Program

    line input menu '"calculator" = calc,"DOS prompt" = dos,"exit"': ans$ 
    if  _exit  then  exit do
    select case ans$ 
    case 'CALC' 
      pass nowait: 'calc' 
    case 'DOS' 
      pass nowait: '$$' 
    end select

RUN this program by clicking on the Run icon in the SPDEV toolbar---the running man.

The following menu will appear:

Click on the word Calculator in the menu. The program will run your Windows calculator program.

Click on DOS prompt in the menu. The program will run the MS DOS Prompt (or Command Prompt) program.

Click on EXIT or the [X] to close the menu. The console window will appear. Close it by typing in exit and pressing [Enter], or by clicking on the [X] in the top right corner of the window.

1.2.2 Saving a Program in Sheerpower

To SAVE your program in SPDEV, click once on the Save icon in the SPDEV toolbar---the floppy disk icon.

You can also click on File in the SPDEV toolbar and select Save from the drop down menu.

If you have multiple files open in SPDEV that you wish to save, click on the Save All icon in the SPDEV toolbar---the icon with three floppy discs together.

Note that each time you RUN a program file from SPDEV, the file is automatically saved.

Next Contents Index