Delete: DEL  

 

Execute the delete function from the current Beas window.

In the delete definition (Ctrl+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 the delete definition with:

Delete:no        Avoid deleterow()        

Delete:close        Close the form after successful deletion        

Delete:update        Do not update after deletion        

         

 

Example for a 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