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!!
julian@ecsvax.UUCP (08/16/84)
The END OF FILE FOUND UNEXPECTEDLY usually happens when I used indexed files, but you would not be sorting them is you used an index. Assuming that you can DISPLAY the file, then you must have a trashed file with an EOF character somehow inserted. If not, then kludge it by issuing a USE or two in order to close the file, then USE it again and SORT to your destination. A little more information would pinpoint the proper kludge. Phil Julian mcnc!ecsvax!julian
LIN@Mit-Mc.ARPA (08/22/84)
From: Herb Lin <LIN@Mit-Mc.ARPA>
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.
I'm told that there is a very strange bug with the SORT function of
dBase II. The way to get around it is to do an INDEX and then write
out the indexed file. [So say the sharpies at Gifford Computer Systems.]