Contents

Introduction

Welcome

What is the purpose of this document?

Who is this document intended for?

Other sources of information on Superbase

Superbase Overview

The History of Superbase

Superbase versions and revisions

Superbase's Strengths and Weaknesses

Comparing Superbase to other DBMS systems

Basic Superbase Stuff

Observing problems with Superbase applications

Preventative Maintenance of Superbase applications and files

Reorganizing Superbase database files

Making Changes to Applications

File definition modifications

Form modifications

Report modifications

Code (SBL) modifications

Programming and Code Changes

Program editor basics

Three styles of applications

Different code styles

Coding strategies

Global vs local and hidden variables

Run vs Chain vs Load

Procedure libraries

Structuring the code

Basic input/output flow

Control of flow statements

Procedure design

Programming subjects

(See the Help File)

Debug and Troubleshooting

Debugging Superbase applications

Troubleshooting Superbase applications

Using the macro recorder to help debug

Major Differences for Upgrades

Detail Block handling

File and record locking

Objects and the object model

Recoding portions of an applications

Which form of Basic to use?

File locking issues

SQL vs SBF

Performance Issues

Filtering records

Indexes quantity vs quality

File size and file blocking

Proper INI file setup

Testing Testing Testing

Testing incremental improvements

Testing the entire system

Other development resources

Working with the supplies samples

Using the procedure libraries

Using the Superbase help file

Finding additional help on the internet

Appendix

Superbase Support Services