I accidently re-opened all closed work orders. The syntax I used is: Update [Order] Set Closed=0 Where Type=2 AND Closed=0
Please tell me how to repair the damage.
Thanks!
I accidently re-opened all closed work orders. The syntax I used is: Update [Order] Set Closed=0 Where Type=2 AND Closed=0
Please tell me how to repair the damage.
Thanks!
hi Jzlf, After reading your below sql query I didn't see that you did anything wrong just try to understand what you done you raise the statement Update [Order] Set Closed=0 where Type=2 AND Closed=0 so basically you made nothing you set the closed to zero and also you specified the where condition as also closed=0 nothing happen. or may be below you are writing the wrong query.
Please send the correct query as nothing wrong with below:
"jzlf" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.