Records can be deleted from blocks containing multiple rows, either from a child block or on a screen in list mode.
The code for this is simply:
DeleteThisRow();
The code will create a delete statement against the table assigned to the block with a where clause including the key fields and values for the block. For example, if deleting an item number from table item_master_uvw in an Oracle datasource, where the primary key marked for the block is the item_no field and the item number being deleted is ITEM0001, the delete statement would be generated as:
DELETE FROM ITEM_MASTER_UVW WHERE ITEM_NO = 'ITEM0001'
To create a Delete link, if rows can be deleted, add a field to the block that is a non-database field.
Set up the field as a Hyperlink field. Set the Hyperlink Scripted flag to true.
In the Hyperlink property for the new field, enter DeleteThisRow();
Press the Save button.
The Delete link can contain additional checks, such as verifying that the user wants to delete the record, or if you have new rows, checking to make sure the row exists before deleting the row. In addition, for new rows, there is different code to clear the record because the row doesn't yet exist in the database.
To verify that the user wishes to delete the row before completing action, add the following code:
var agree=confirm('Do you wish to delete this record?');
if (agree)
{DeleteThisRow();}
When the user clicks on the link, a pop-up message will be displayed containing the question within the confirm parentheses, and two buttons - ok or cancel. If the user presses ok, the agree value is set to true. If the user presses cancel, the agree value is set to false. Then, if the agree value is true, the delete statement is generated and executed against the database. If the agree value is false, nothing happens.
If you have new rows, you can check to make sure the row exists before trying to generate a delete statement to execute against the database. Otherwise, the user might get an error message stating that there is nothing to delete. To check to see if the record exists, add the following code:
if(RowExists())
{DeleteThisRow();}
If you have new rows, and you want the user to be able to clear the row if they wish, you can enter the following code to allow them to clear the row.
ResetRow();
You can combine all of the code above as follows:
var agree = confirm('Delete this Record?');
if (agree)
{
if(RowExists())
{ DeleteThisRow(); }
else
{ ResetRow(); }
}
This code confirms that the user wants to delete the row. Then, if the user does, it checks to see if the row exists. If the row exists, it deletes the row from the database, otherwise it resets the record on the screen.