The following program enables you to sort the existing binary file "c:\sortin" of which the record length is 100 bytes in ascending order to make the external decimal number in 4 bytes from the 20th byte of the record as a key field. It is an example of describing the code to delete the other codes keeping only 1 record when 2 or more records that have the key field with the same value exist, and output the result to the binary file "c:\sortout".
Private Sub Command1_Click() 'Specify not to display the error message. PowerBSORT1.DispMessage = False 'The sort processing is specified. PowerBSORT1.DisposalNumber = 0 'Specify to sort the external decimal number in 4 bytes from the '20th byte of the record in ascending order as a key field. PowerBSORT1.KeyCmdStr = "19.4zdla" 'If the specified key fields have the same contents, 'it is specified to keep only 1 record and delete the others. PowerBSORT1.HandlingSameKey = 2 'The input file name is specified. PowerBSORT1.InputFiles = "c:\sortin" 'Binary fixed length is specified for each input file type. PowerBSORT1.InputFileType = 1 'The output file name is specified. PowerBSORT1.OutputFile = "c:\sortout" 'Binary fixed length is specified for each output file type. PowerBSORT1.OutputFileType = 1 'The length of the record is 100 bytes. PowerBSORT1.MaxRecordLength = 100 'The processing is executed. PowerBSORT1.Action 'Processing when an error is found. if PowerBSORT1.ErrorCode <> 0 Then Msgbox "An error was found in PowerBSORT." & " ErrorDetail=" & PowerBSORT1.ErrorDetail Exit Sub End If End Sub