Question "Are you sure you want to delete all records?" is only shown once per PLD instance

[Claus Pedersen]

When I execute the command "DELETE myTable" in a SQL window, PLD asks: "Are you sure you want to delete all records?". I answer Yes (press Enter) and the table rows are deleted. I do not check the ckeckbox "Don't show this message again"). This is by design.

But when I execute the command "DELETE myOtherTable", this time I get no warning question. Even if I open a new SQL window, I still get no warning. It is only the first time in a PLD instance you delete all table rows, that you get the question, the next time you perform the same operation in the same instance, you get no question.

If you execute the command "DELETE myTable WHERE 1=1" (same result as the first delete), you get no warning question.

In my opinion, the warning question could be removed completely from the application, as it only works in some specific cases.

 

[Marco Kalter]

This works as designed for the case where you forget to specify a where clause before executing. It assumes that, once you accept this, it does not need to continuously need to warn you for the same situation.

A where clause like "where 1=1" is not a case where you have forgotten the where clause.

 

[Claus Pedersen]

But there is a "Don't show this message again" checkbox in the Confirm dialog. I have not checked this checkbox, so I would expect to see this message again the next time, I perform the same operation.

The checkbox option should be removed and the text could be added a comment like: "Notice: you will not be asked about this again in this PLD session"

But not a serious bug/feature, put it at the end of the "Enhancement list" ...

 

[Marco Kalter]

Okay. I have added this to the list of enhancement requests.