home *** CD-ROM | disk | FTP | other *** search
-
- 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