Delete: DEL  

 

 

Without Settings:

The actual Row will be deleted and an update will be called.

You can control the workflow with:

Delete:no        Avoid ddeleterow()        

Delete:close        Close the Form after successful deleting        

Delete:update        Do not Update after Delete        

         

 

important Commands

         

sql=select count(*) ..        Retrieve Count for a given table. Return value will be provided in <wert1>

sql=delete from ...                Delete from Table...

return failure                Cancel Deleting

         

 

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

 object=ue_system_tools=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