Approved Workman Database

Community Contributions => SQL Workbench => Topic started by: James on August 04, 2011, 04:52:24 PM

Title: Deleting Notes from multiple clubbers
Post by: James on August 04, 2011, 04:52:24 PM
I make a lot of notes in the "Notes" section of my clubbers file.  I set up my New Club year but the notes from last year are still there.  Is there a quick method to delete all the old notes or do I have to edit each clubber individually?

Thanks!

James
Title: Re: Deleting Notes from multiple clubbers
Post by: Rick Leffler on August 04, 2011, 06:22:54 PM
If you really want to wipe out all of your notes, you can use the SQL workbench (Admin > Database Utilities) to do this.  Use the following statement:

                              update Person set Notes = null

if you only want to clear the notes on Clubbers but not Leaders you could use:

                             update Person set Notes = null where Member_Type = 'Clubber'
Title: Re: Deleting Notes from multiple clubbers
Post by: James on August 06, 2011, 11:20:48 AM
Awesome!  Thanks!