Question

Excel As Database DELETE SQL QUERY does not work

  • 2 February 2023
  • 1 reply
  • 98 views

Badge

Hi All,

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.

 

 


1 reply

Userlevel 7
Badge +13

Hi @bahayamaricar.cantal ,

 

Try the query without -;- symbol. 

 

 

Reply