Update more than one selected records ?
Hi experts,
How to update
Status = "Paid" where
Invoice_No = "test" ?
BTW, I managed to update 1 instead of 3 records using the script below:
Please advise, many thanks. :)
- // Assume rec = "test"
- rec = Invoice[ID == input.Invoice].Invoice_No;
-
- for each sel in Delivery_Order[Invoice_No == rec]
- {
- UpdateStatus = Delivery_Order[Invoice_No == rec];
- UpdateStatus.Status="Paid";
- }
Delivery_Order