John Bleau Programming - Technical Page
Code samples and documentation that we're sharing over the Internet

With the development of our applications, we have built up a large library of code that may be useful to other programmers. However, time restrictions force us to begin modestly.

HTML Primer
This isn't code, but a primer on HTML with links to more extensive documentation.

SQL Base [Delphi 5]
This is a really useful tool for Delphi programmers who need an SQL tester and generator. There's a link to an SQL instruction site within the application itself.

Paradox Runtime (BDE) [Delphi 5]
The Borland Database Engine allows us to do a great number of things with our Paradox tables - but it ain't simple!
The reason we opted for the BDE rather than using SQL commands such as:
ALTER TABLE "YourTableName.db"
ADD NewFieldName CHAR(35)
is that the SQL resulted sometimes in our being no longer able to repair the table if corrupted or to restructure it with the BDE.
Here's some working code from which the programmer will learn the basics and branch out. Links included.
ChangeRec & Paradox Field Types The prerequesite to the following links. You must understand these first!
Adding a field (BDE) To add a new field to an existing table.
Altering a field (BDE) To alter an existing field.