pfd
Reputable Poster
A user ran R31410 wide open and updated all our Work orders to the wrong status. Now I am trying to update it back to the correct status.
But my SQL below is blanking out the WO status.
Here is my SQL:
update py/f4801 a set a.wasrst =(select b.prurcd from
py/f55pr b where a.wadoco=b.prurab and
a.wamcu=b.prmcu and a.wamcu=' 123100') where exists
(select * from py/f55pr b where a.wadoco=b.prurab and
a.wamcu=b.prmcu and a.wamcu=' 123100')
When I do the Select it does come back with the right # of records. But I cant figure out why it is blanking out the status. The URCD field does have the right status. Any ideas would be much appreciated.
Thanks,
Matt
But my SQL below is blanking out the WO status.
Here is my SQL:
update py/f4801 a set a.wasrst =(select b.prurcd from
py/f55pr b where a.wadoco=b.prurab and
a.wamcu=b.prmcu and a.wamcu=' 123100') where exists
(select * from py/f55pr b where a.wadoco=b.prurab and
a.wamcu=b.prmcu and a.wamcu=' 123100')
When I do the Select it does come back with the right # of records. But I cant figure out why it is blanking out the status. The URCD field does have the right status. Any ideas would be much appreciated.
Thanks,
Matt