‎Apr 29, 2020 09:57 AM
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
‎Apr 29, 2020 01:54 PM