"ORA-00903: invalid table name" from JScript, works good from Toad

Question

I have a query to update state_id for one row in a table:

UPDATE EVENTS
   SET final_name = 'bla-bla-bla',
       transaction_Date =
          TO_DATE ('2014-09-08T03:29:57', 'YYYY-MM-DD"T"hh24:mi:ss'),
       state_id = '90'
 WHERE     ROWNUM <= 1
       AND state_id = '2'
       AND ufm_id IS NOT NULL
       AND violation_event_id IS NOT NULL
       AND violation_Event_type_id = '1';

When I am executing this query from Toad everything works like a charm (with commit or without). When I generate exactly, double checked, the same query from JScript (in SmartBear TestComplete) I am getting an error: ORA-00903: invalid table name. I copy generated query from debug output, paste it to Toad - works well.

Found the mistake: RTFM - I cannot update by "UPDATE..." query execution, in adodb I need to read recordset by "SELECT...", assign new values and execute recordset.update. Recordset examples