Firstly I don't recomend it but understand why people want to do it, you feel like you are going under with unpointed points, so you want to remove all the unpointed points from the app so you can just start again with the daily and weekly sheets.

You have a couple of options, both require scripts which I will give you examples of, the first one will delete all your unpointed points, this is non-recoverable so make sure you really want to do this beforehand, I recomend that you go into maintance in the Apple apps and do a database backup first.

This script will delete all the unpointed points.

delete from tblpoints where pstatus_type=1

This script will delete all the unpointed points that are less than 5 times asked.

delete from tblpoints where pstatus_type=1 and times_asked < 5

both these commands need to be typed into maintenance/advanced and then the execute button pressed.


 

Last edited by Alex (1/17/2015 2:48 pm)