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.
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: