Wiedemann@RADC-MULTICS.ARPA (08/09/84)
I have CP/M dBASE, Version 2.4. There appears to be a problem with the "SORT" function. Whenever I try to SORT ON <field> TO <file>, I get a "END OF FILE FOUND UNEXPECTEDLY" message. Not only that, but even after a CLEAR, I cannot erase the destination sorted file without incurring a FILE ALREADY OPEN message. When I try another CLEAR followed by a USE with the sorted destination file, I get a NO DATA BASE IN USE message. Can anyone shed any light on this? Is it me or my dBASEII? Is there a fix? Wolf Wiedemann RADC-MULTICS P.S. I have verified correct format of the source file I'm trying to sort. Every time I QUIT out of dBASEII and re-enter it, USEing the sorted destination file, all I ever see on a DISPLAY ALL is the first record of the source file, repeated ad infinitum. HELP!!
pencin.dlos@XEROX.ARPA (08/13/84)
Some place along the way you ended a DBASE session without doing a quit. The is now an EOF in an incorrect spot in the file, thus your error. To recover you must copy the entire file into another and delete the one you are using. Hope thisworks for you. If you have DU or DPATCH you can delete the offending 1A in the file directly. russ
RDones.es@XEROX.ARPA (08/13/84)
Wolf; 1. EOF unexpectantly could be occurring because of a blank record within your .dbf. Do a query for a blank record. If found delete it and pack your .dbf. Chances are your have some type of bad record. 2. FILE ALREADY OPEN: If you have selected a secondary file and forgot to "use" while in the secondary mode this type of error could occur. 3. DO DATA BASE IN USE: I think now you're just compounding your 1st problem. Solve problem 1 first and I believe the rest will go away. Good luck Rene