Daboo DBISAM Maintenance

Version 1.0.0.87
Copyright 1997-2002 David Dienhart All Rights Reserved.
Release Date: 01-01-2003
http://www.dienhart.com
Questions or comments? E-mail us at software@dienhart.com

Files

• DDBISAMMaint.exe (Program)
• DDBISAMMaint.html (Documentation)

Requirements

• Win98, NT, 2000, XP
• DBISAM 3.00 formatted tables.

Description

Stand-alone utility to Verify, Optimize, and Repair DBISAM version 3.00 tables. Handles command line variables, to allow for tighter integration with applications.

Setup

• If you are using the application as stand-alone, copy the DDBISAMMaint.exe file to a directory of your choosing, execute and use.
• If you are using the application called from another app, copy DDBISAMMaint.exe to the directory your app is executed from. You can include DDBISAMMaint.exe in your install routine.

Usage

Execution

• You may execute DDBISAMMaint from the command line
• The following command line switches may be used:
  dbpath: path to your database, may be virtual.
  pwd: Password used to encrypt your database (must have to perform maintenance functions without being preempted for a password)
  pwd1: If you use multiple passwords among your tables, you may want to use pwd1-4 as well.
  pwd2: Same as pwd1
  pwd3: Same as pwd1
  pwd4: Same as pwd1
  restart: Upon exiting DDBISAMMaint.exe the application indicated here will be called.
• Example: DDBISAMMaint.exe dbpath=.\data\ pwd=000000 pwd1=111111 pwd2=222222 pwd3=333333 pwd4=444444 restart="c:\Program Files\Your Directory\Your App.exe"
  restart may also be a virtual path to your application or just the name of your app if DDBISAMMaint and your app are in the same directory.
• Delphi code snippet example used to call DDBISAMMaint:
  procedure TPersonalEvaluation.DatabaseTools1Click(Sender: TObject);
  var MaintApp : PChar;
  begin
    MaintApp:='DDBISAMMaint.exe restart=PersonalEvaluationTracker.exe dbname=.\data\';
    WinExec(MaintApp, SW_Show);
  Close;
  end;

Interface

• Upon Executing, if you used the dbpath switch, your tables should be listed, if not verify that your path is correct.
  If you did not use the dbpath switch, no tables are listed. Right Click your mouse and select "Directory Selector". Select the Drive and directory of your database.
• Select the table(s) you would like work with, and click one of the buttons defined below.
• Verify Button: Verifies a table and sees if there is any damage or corruption that may have occurred in a database table due to an improper operating system or application shutdown.
• Optimize Button: Optimize the physical organization of a table on disk according to a specified index, and permanently remove any free space from the table.
• Repair Button: Repairs any damage or corruption that may occur to a database table due to an improper operating system or application shutdown.
• Force Index Rebuild, rebuilds the index when a table is repaired.

Notes

• If no the pwd switch is not used from the command line and a table is password protected, you will be prompted to enter the password before being allowed rights to the table.
• If any spaces are used in the command line switches, you must use quotes on the value:
  example: DDBISAMMaint.exe dbpath="c:\Program Files\Your App\Your Database"
  (The same holds true for spaces in pwd and restart)
• As This utility requires exclusive access to the database for maintenance, your database application must be closed to perform any maintenance features.

History

• Initial Release