Show all button

Ok resultset is 1000 by defaul, showall shows 100.000 which is set somehere in settings.

Sometimes I would like this behaviour:

Click on "Show all", does what it does + changes it's caption to "Do not show all" & changes underlying logic to that.