|
|
|
The conversion process from DOS to WIN may also create some blank records. The most likely places for this to happen would be the module master file and the history file. As with any non-standard activity, a copy of the file should be made or an extra backup made just prior using any of these special techniques. In addition, a control report, trial balance or other such balancing report should be run before and after using any of these advanced solutions. (gps) Using UTICMS, open the file in question.
|
Locate the blank row (again usually the first or last row).
If the blank records are hard to find, use the sort feature by any of the data
fields. Then highlight the Record Number.
A blank record is considered to be any row that has only a Record Number, or only a Record Number and incomplete or corrupted data in the rest of the row.
Using UTICMS, open the file in question. Locate the blank row (again usually the first or last row), and highlight the Record Number. Then select Record and Delete/Undelete. Notice that the Record Number is now followed by an asterisk (*). The asterisk indicates that this record will be ignored by any report or by any program code that would normally be looking at the file. At this point, you can toggle between Delete and Undelete to either ignore or use the data in the row.
Once you have located and flagged all blank rows, pack the files to physically remove the rows from the data file. Select File and Pack to do this. Once you have packed, the blank rows are gone and you can no longer toggle between Delete and Undelete on the blank row.
Then select Record and Delete/Undelete. Notice that the Record Number is now followed by an asterisk
(*). The asterisk indicates that
this record will be ignored by any report or by any program code that would
normally be looking at the file. At
this point, you can toggle between Delete and Undelete to either ignore or use
the data in the row.
Once you have located and flagged all blank rows, pack the files to physically remove the rows from the data file. Select File and Pack to do this. Once you have packed, the blank rows are gone and you can no longer toggle between Delete and Undelete on the blank row.
