Hey I want someone to check this DQL if there is any mistake

Ken_Antwi

 

I wrote this

DQL> update dm_sysobject objects set r_lock_owner='' where folder('/4. Archives,descend) and r_lock_owner='Julie Sam';

And I'm getting error

[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: update dm_sysobject objects set r_lock_owner='' where folder('/4. Archives,descend) and r_lock_owner='Julie"

　

Any thing that Im doing wrong. Please can someone help! Thanks

PanfilovAB

missed single quote

update dm_sysobject objects set r_lock_owner='' where folder('/4. Archives',descend) and r_lock_owner='Julie Sam';