Approved Workman Database
Community Contributions => SQL Workbench => Topic started 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
-
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'
-
Awesome! Thanks!