D
Dnyati
Guest
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 :
It gives Incorrect syntax near 'B'. Any idea where it went wrong.
Continue reading...
Code:
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...