Thursday, January 14, 2021
Tip of the Day: Improved Confirmation for "All Row" Table Deletions
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.3.20112 or higher
Sections......: Data Browser, Commands
Keywords......: Delete, All Rows, Confirmation, R> Prompt
Did you know that when deleting "all of the rows" in a table, the
Yes/No confirmation
message was replaced with a dialog where the user must enter the word
"delete" in
order to continue?
Within the Data Browser, when the "Delete All Rows" menu option is
selected, the prompt
to confirm the deletion has been enhanced where the word "delete"
must be entered in
order to remove the data.
When the DELETE command is used at the R> Prompt to remove all rows
within a table, the
prompt to confirm the deletion has been also been enhanced where the
word "delete" must
be entered in order to continue. The DELETE command prompt would only
pertain to R> Prompt
command entries, not when a command file is running.
The improved confirmation for "all row" table deletions, makes the
user think a bit more
before inadvertently deleting every row!
Notes:
The dialog to confirm the delete of all rows comes up when these two
conditions are met:
01. Input is coming from the keyboard (not from a file or stored procedure)
02. The delete does not have a WHERE clause at all
If you want to delete all rows from the browser and do not want to
have the dialog
confirmation, I would add a WHERE clause that will qualify every row.
Here is a sample:
DELETE FROM tablename WHERE 1 = 1
This command has a WHERE clause so the dialog will not be shown, but
clearly every row
will meet this WHERE clause.
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0M7ZR3-1lxLC93cHv-00xNSy%40mrelay.perfora.net.
