×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

dBASE III + sorting problem

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 !

RE: dBASE III + sorting problem

Does the DBF have associated indexes?  If so are they open when you append or add the records.   Are you appending in mass or adding one at a time thru a interface.

Jim C.


RE: dBASE III + sorting problem

To sort a table you need 3 times the drive space free that is equal to the size of the DBF + FPT + IDX's open.  

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

Just thought of another way
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

(OP)
Thanks for the replies. The DBF does have 3 associated indexes, but I do not have them opened when I try to sort the file. I am appending in mass, not through an interface.
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

Could one of the sorted fields be encountering a non-ASCII character in one of the records being added?  Sometime the characters outside normal ranges such as below ASC(32) cause problems in indexes, especially ASC(0).  Maybe that goes for sorts too?

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...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close