[Stackoverflow] [Progress OpenEdge ABL] Incorrect Syntax Open Query

[Dnyati]

I an doing update using open query on progress database which is connected to sql server using lined server . below is the query when I print :

   UPDATE OPENQUERY(PROGRESSDB,'SELECT * FROM PUB.workitem where 
 act_emp= 73870 and wtype='B'')
SET  start_time='81410',logonstat  = '1',realstrttme ='81410'

It gives Incorrect syntax near 'B'. Any idea where it went wrong.

Continue reading...