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!
HELP URGENT!
Aug 22, 2007
1 Replies
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required