(800) 771-9182

COMM ONE CALL ACCOUNTING SOFTWARE
FAQ-1452 How to Delete Calls for a Year

HOW TO DELETE CALLS FOR A YEAR

The Comm One Toolbox allows you to enter commands that are run globally on a complete data file.  That way you can quickly modify your data as needed without having to edit records one at a time.

HOW TO ACCESS THE TOOLBOX COMMAND LINE

1. Close all programs

2. Open the Comm One Software Folder on the Desktop

3. Open the UTILITIES folder.

4. Double Click the TOOLBOX icon.  

5. You will be taken to the toolbox command line editor.
    

The following commands are entered in the ToolBox Utility.  If the command is successful the command line editor will return without error.  If you make a mistake in typing the command, you will see an error message.  In that case, you should type CLOSE DATABASES and start the commands over again.

TOOLBOX COMMAND TO DELETE CALLS FOR A WHOLE YEAR
To delete old call records from the toolbox for all of 2020 at the ToolBox command utility you would type the following commands:

• CLOSE DATABASES

• SELECT A

• USE PLM_CA.DBF

• COPY TO HISTORY.DBF

• DELETE ALL FOR SUBSTR(DATE,7,4) = "2020"

• PACK

• BROWSE NORMAL
   

Then scroll to the top and make sure they are gone.  Then press ESC to exit the browse and type QUIT and RETURN to exit the toolbox Utility.

TOOLBOX COMMANDS TO DELETE CALLS FOR A SPECIFIC MONTH.
To delete calls for a month you need to specify the month (1,2) and the year (7,4) in your substr command.
 

To Delete calls for July 2020 you would type:

• CLOSE DATABASES

• SELECT A

• USE PLM_CA.DBF

• COPY TO HISTORY.DBF

• DELETE ALL FOR SUBSTR(DATE,1,2) = "07" .AND. SUBSTR(DATE,7,4) = "2020"

• PACK

• BROWSE NORMAL

​​​
Then scroll to the top and make sure they are gone.  Then press ESC to exit the browse and type QUIT and RETURN to exit the toolbox Utility.