to:   Borland Tech Support

from: Andy Most  (73577,1353)
      Dun & Bradstreet
      150 Mt. Airy Rd.
      Basking Ridge, NJ 07920
      (201)-953-5619


    We recently purchased the TP4 toolkits. I have been evaluating the DataBase
Toolkit (serial #D4A0121539)  and have encountered what I belive to be a bug in
TACESS.  When a Database with a large number of records is created, FINDKEY
seems to fail.


The tests were on a COMPAQ Deskpro 386/20 using COMPAQ DOS 3.31.  AST
Superspool, DOSEDIT, and DOORS are resident.

    This ARC file contains 3 programs that will demonstrate the bug.  They
create a database with a 1 byte key representing a STATE field (53 states
including Puerto Rico, Virgin Islands, Washington DC). The data associated
with the key is a count.  The report program will search all records for a
state or states and accumulate the count totals.

 files included:

  TEST.TYP - this was used with TABUILD

  TESTDATA.PAS - Generates a "source" file for the data base TESTDATA.NEW
                 The program prompts you for a number of records per state,
                 allowing you to control the size of the test data file.
                 My own tests were with values of 10, 100, and 1000.  The
                 REPORT program fails in FINDKEY when 1000 is used.

  BUILD.PAS - Generates TATEST.DAT and STATE.IDX from TESTDATA.NEW

  REPORT.PAS - A simple report generator.  For testing, all states are selected
               when you start the program.


NOTE: I suspect that one of the TACCESS routines is using an integer variable
instead of a longint and that this variable is incremented above 32k when
searching a large database.

  There's no rush on this.  I'm only testing your product.  If you do find a
fix, let me know.


                        Thanks,


                        Andy Most