Delete: DEL
Execute the delete function from current beas window
In the delete definition (Crtl+N+B - DataWindow - Delete) you can define the additional functionality.
Without Settings:
The actual Row will be deleted and an update will be called.
You can control the workflow inside delelete definition with:
Delete:no Avoid ddeleterow()
Delete:close Close the Form after successful deleting
Delete:update Do not Update after Delete
Example for an typical approach:
question=Do you want to delete==return failure
select count(*) from beas_stlpos where art_id=<s_parm1>
if <wert1> n> 0 then
messagebox=error$subentrys found! Position can not deleted!
return failure
end if
// Delete now and close window:
delete:close
(if "Delete" has been chosen than nothing else need to be declared. Because the normal Delete sequence will be executed).
Example: Delete with xxx
question=do you want to delete <firmname>?==return failure
sql=select count(*) from oitm where firmcode=<firmcode>
if <wert1> n> 0 then
question=Subentrys exists! Generate Sublist?==return failure
isql=select itemcode+'' as Itemcode,substring(itemname,1,30) as Description from &
oitm where firmcode='<firmcode>'
return failure
end if
// Delete Entry and Close
delete:close