HELP URGENT!

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!

Reply to
jzlf
Loading thread data ...

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:

Reply to
Akber Alwani

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.