I am trying to delete a row based on a condition using Database Command in Automation Anywhere. Below is my code:
DELETE FROM [outstanding alert$$] WHERE [Status] = 'PB_RM Investigation';
I am getting error “This may be due to the following reason: - There is a syntactical error in the SQL statement. - SQL statement got timed out. “
Appreciate your help on this. Thank You.
Try the query without -;- symbol.