Sheerpower Logo
K.3  Create Your First ARS Database Table
Sheerpower includes an integrated database system called ARS (Advanced Record System). ARS is designed to deliver high-performace database table read/write access with full concurrence at the record level. Table sequential access and lookup speeds of over a million per second are typical.
Note: To create an ARS table you must first download and install Sheerpower.
This typically takes less than five minutes.

Once you have installed Sheerpower, run the SPDEV.EXE program. It should be on your desktop. If not, using Windows search, find and run it.

In this example, we will create a simple PAYROLL table and give it some fields:
  • A nine character ID field
  • A full name filed of 30 characters
  • and salary field, which will be numeric, nine characters, two of which are decimal digits
By convention, we create tables in the \data\ folder, and we create source programs in the \source\ folder.
Below are the steps to create our PAYROLL table:

Hide Description

    

       


      

Enter or modify the code below, and then click on RUN

Looking for the full power of Sheerpower?
Check out the Sheerpower website. Free to download. Free to use.
Wide screen