dBASE III + sorting problem
dBASE III + sorting problem
(OP)
Hi,
I have a problem that I hope someone can help me with.
I have a dBASEIII+ database file that has 192,456 records in it. I recently added 276 records to it and then tried to sort the file. It progressed to 82% sorted and then displayed the following error: Records do not balance (program error). 192732 100% sorted 192732 Records sorted56 639856 3. I then deleted the new records and it sorted fine. I then added a few records at a time and it sorted fine up until a certain point. I have not determined the exact number of records where this occurs. Has anyone seen this error before?
Please Help !
I have a problem that I hope someone can help me with.
I have a dBASEIII+ database file that has 192,456 records in it. I recently added 276 records to it and then tried to sort the file. It progressed to 82% sorted and then displayed the following error: Records do not balance (program error). 192732 100% sorted 192732 Records sorted56 639856 3. I then deleted the new records and it sorted fine. I then added a few records at a time and it sorted fine up until a certain point. I have not determined the exact number of records where this occurs. Has anyone seen this error before?
Please Help !
RE: dBASE III + sorting problem
Jim C.
RE: dBASE III + sorting problem
It is best to close/delete your indexes Add the records, sort the records, reindex.
Check the drive space. If your doing it on a network drive, make sure you have allocated enought usable drive space for the operation.
David W. Grewe Dave
RE: dBASE III + sorting problem
Open DBF and Index on the sort method to use
Add the records
reindex
copy to sorted.dbf
close tables
delete orgdbf
rename sortdbf to orgdbf
(same for FPT if one)
then open all indexes and reindex.
that would take up less drive space for the operation.
David W. Grewe Dave
RE: dBASE III + sorting problem
The file is just over 16MB in size and I have tried to sort it on both my hard drive (62GB of free space) and a network drive (104GB of free space) with the same results. I have gotten around the problem by splitting the DBF into two DBFs and adding the records to the appropriate DBF and then appending them back together. Obviously I would like to resolve the problem as I need to add to this DBF on a regular basis. Could ram (my computer has 2 GB)be a limiting factor? Thanks again for your time.
RE: dBASE III + sorting problem
But if you do the same thing in the table when it is split in half and it works, then maybe that's not the problem. Could it be that the table has hit 16MB in size? I don't recall the limits of dBaseIII+ offhand...