Author Topic: Deleting Notes from multiple clubbers  (Read 1399 times)

James

  • Newbie
  • *
  • Posts: 3
Deleting Notes from multiple clubbers
« 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

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 327
    • Approved Workman
Re: Deleting Notes from multiple clubbers
« Reply #1 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'
Rick at Leffler Systems
Murfreesboro, Tennessee

James

  • Newbie
  • *
  • Posts: 3
Re: Deleting Notes from multiple clubbers
« Reply #2 on: August 06, 2011, 11:20:48 AM »
Awesome!  Thanks!