List of utilities for support of Btrieve database projects. by Dale Thorn -- Revised 04.08.2002 PRIMARY UTILITIES (import, export, copy, modify, delete, and report data) ------------------------------------------------------------------------------- Browse.bas Functions supporting BROWSER.BAS. Note that this is the only "include"/support functions file in the toolkit that requires a separate compilation from the main BAS file (BROWSER.BAS). (See C80MCB1.BAT and BROWSE.OBJ references below.) Browser.bas Browse any Btrieve file with the appropriate script (generate automatically using CMAKx utility if table detailed in DDF's). Multi-table joins and multiple search fields are supported. Complete list of features is found in BROWSER.TXT file. Trimprt.bas Minimize width of output/report files generated by BROWSER utility, by removing redundant blank spaces from printed text columns. Btrvcopy.bas Copy whole Btrieve records, or specific fields described by a script (generated automatically using FMAKx utility, if table detailed in DDF's). Multi-table source data is supported, and record lengths may be changed with Compress and Expand options. Btrvload.bas Import records from various formats to a Btrieve file, using a script (generate automatically using FMAKx utility if table detailed in DDF's). Btrvsave.bas Export records to various formats from a Btrieve file, using a script (generate automatically using FMAKx utility if table detailed in DDF's). Btrvupdt.bas Insert, delete, or modify one or more records in a Btrieve file. Flexible auto-increment field options, including non- numeric text types, and reset on key change. Insertions are duplications of existing records with new user-entered key field values. Fixcsv.bas Modify MS-Access output text ('CSV') files to eliminate currency symbols, embedded commas in fields, and quotes around text fields. The resulting text file may then be imported into a Btrieve file using the BTRVLOAD utility. SECONDARY UTILITIES (create new Btrieve files) ------------------------------------------------------------------------------- Mcre.bas Create a '.CRE' (Btrieve-create) script file from the DOS piped output of a BUTIL -stat operation on a Btrieve file. Bcre.bas Create a new Btrieve file using the '.CRE' script file described above. Btrvfcre.bas Functions supporting BCRE.BAS. SUPPORTING UTILITIES (repair files and generate statistics) ------------------------------------------------------------------------------- Fixbhdr.bas Replace a damaged Btrieve file header so that some or all of the records can be recovered using BUTIL.EXE, DUMPBTRV.EXE, or BTRVCOPY.EXE using the '/KP' (physical sequence) option. Dumpbtrv.doc Describes the complete process and several tools for recov- ering a Btrieve file which contains a damaged header page. Btrvlen.bas Verify the record length of a Btrieve file. Usually called from a DOS "batch" file to validate the record lengths of all Btrieve files used in a given database. Btrvver.bas Verify the version number of a Btrieve file. Usually called from a DOS "batch" file to validate the version numbers for all Btrieve files used in a given database. Cmakb.bas Create a series of script files used by the BROWSER/B1.EXE utility. The script files have extensions of '.CF0', '.CF1', '.CF2', etc., corresponding to each key that the DDF data dictionary specifies for a particular Btrieve table. Note that two or more table definitions may be specified for a single Btrieve file. Cmaks.bas Same as CMAKB.BAS except default string key segments to "uppercase collating". Filestrb.bas Create a Btrieve table "file layout" document listing field and key information for that particular Btrieve table. Fmakb.bas Create a script file used by the BTRVCOPY, BTRVLOAD, and BTRVSAVE utilities for importing and exporting data. This version of the script uses the actual Btrieve DOS filename to import/export data in the "CSV" format, or copy the data directly from one Btrieve file to another using the script. Fmaks.bas Same as FMAKB.BAS, except import/export data in the "SQL7" format. This version of the script uses the DDF table name instead of the Btrieve DOS filename, and is used only by the BTRVLOAD and BTRVSAVE utility programs. PRIMARY SUPPORTING FILES (BASIC language "include" files) ------------------------------------------------------------------------------- Basiob1.bas I/O functions supporting BROWSE.BAS and BROWSER.BAS. Btrieve.bas Low-level and high-level Btrieve calling functions. The low-level function interfaces directly with the Btrieve DOS TSR using DOS "interruptx" calls. The high-level function wrappers the low-level call with simplified return status codes. OTHER SUPPORTING FILES (batch files, libraries, create scripts, feature lists) ------------------------------------------------------------------------------- C80mcb1.bat Compiler "batch" file used to compile BROWSE.BAS/BROWSER.BAS. Browse.obj Precompiled copy of BROWSE.BAS required for linking when recompiling BROWSER.BAS. Browser.txt Complete list of features for BROWSE.BAS/BROWSER.BAS. File.cre Btrieve create-file script for the FILE.DDF data dictionary. Field.cre Btrieve create-file script for the FIELD.DDF data dictionary. Index.cre Btrieve create-file script for the INDEX.DDF data dictionary. Note: The above 3 scripts are used to recreate the DDF data dictionaries, which are then populated from the original '.DDF' files, so that the CMAKx, FMAKx, and FILESTRB utilities can access the extra indexes to perform their functions correctly.