For Example - here we tried changing the order status:
Code: Select all
// SQL CODE
begin tran
use Dev_SelectDb
Update [pf].[OrderInfo]
set OrderStatus = '7'
where Number = '161078-XD-AL-RR-KV'
go
update pf.SearchOrder
set OrderStatus = '7'
where Number = '161078-XD-AL-RR-KV'
go
update pfm.[Order]
set Status = '7'
where Number = '161078-XD-AL-RR-KV'
--commit
--rollback
This worked in terms of updating the Database. The change Reflected.
However, the change did not occur in the GUI. Is there any documentation how an order pulls in order Info in the GUI?