cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to Delete data using Business Adapter

 
(1) Reply

Hi,

The Business Adapter Studio does not provide a function for deleting data records; you can only create and edit data. However, you can solve your requirement using the BAS custom query function.

To do this, you determine the appropriate stored procedure (SP) that is required to delete the required objects. The SP always requires corresponding input data, which should then be removed from the system (e.g. AssetID, UserID, ...). The necessary query to determine the data and the actual command to execute the stored procedure to delete the data is placed in the custom query. This also gives BAS the possibility to delete data

SP for removing data can be found on the SQL Server in the corresponding database and usually contain the abbreviation "Remove" in the name

Best,

Dennis