I.3  Create Your First ARS Database Table Watch Video ×

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: