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.

Businessman in a shirt and tie reading a report

SEE ALSO:
 

Comm One Logo - Grey - WIX Header.jpg

Comm One Call Accounting Software

Technical Support

P.O. Box 759

Draper, UT  84020

(385) 529-5819

support@commone.com

FAQ-1452 How to Delete Calls for a Year

Posted: 02/02/2017

Updated: 01/31/2020

Author: Comm One Technical Support