Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!usc!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!LOGNET2.AF.MIL!gautier From: gautier@LOGNET2.AF.MIL (SrA Richard A. Gautier) Newsgroups: comp.sys.misc Subject: dBase III+ Bug- Maybe? Message-ID: <8907262224.AA02102@lognet2.af.mil> Date: 25 Jul 89 21:55:20 GMT Sender: usenet@ucbvax.BERKELEY.EDU Organization: The Internet Lines: 33 Dear Users: I have noticed a problem that I seem to keep having with dBase III+. The problem may be a bug, or I may just not know how to do something. First, the circumstances. 1. I downloaded SIMIBM.IDX which is a comma-delimited file of the MS-DOS directories of Simtel-20. 2. I CREATEd a STRUCTURE in dBase III+ based on the statistics given with the file. I believe they were 4,20,12,2,6,1,6,46. 3. I APPENDed FROM SIMIBM.IDX DELIMITED to read in the records. At this point, everything seemed to be going just fine. It read in over 3000 records, and I could BROWSE through them without any problems, whatsoever. 4. Then I decided to do a DIR, and I noticed that the file SIM-IBM.DBF, which is the name of the file I created, and was browsing through was only about 2K in size (The size of a DOS initialized file before it has been closed). 5. So, in order to close the file, I did a QUIT to exit dBASE, and then re-entered it, only to find that SIM-IBM.DBF has stayed the same size, and I had a corrupted database (i.e. You go to BROWSE, and it bypasses about 7 records, and freezes on the Add New Records (Y/N)? Statement) The only way that I could fix this, was to do my APPEND statement, and then either COPY or SORT the data to another file (which closes both this file, and the other file as far as DOS is concerned.) I a loaded to my hard drive. It does the same thing on a Z-184 with the same stats. Does anyone recognize the problem? Know how to solve it? Richard A. Gautier, SrA, USAF...Osan Air Base, Republic of Korea Automatic Message Sending ASP-User not online-- :)