[QODBC-Desktop] How do I change InvoiceLineItem from InvoiceLineItemRefFullName1 to InvoiceLineItemRefFullName2
Posted by Jack - QODBC Support on 26 October 2015 07:02 AM
|
|
How do I change InvoiceLineItem from InvoiceLineItemRefFullName1 to InvoiceLineItemRefFullName2Problem:How do I go about replacing all Invoices that contain the InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation" First we will fetch data from InvoiceLine table whose InvoiceLineItemRefFullName is "Framing": By Querying:
Note: Invoice has different TxnID, TxnDate & RefNumber. Solution:By executing below update statement in VB Demo, We are able to change InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation" Update InvoiceLine set InvoiceLineItemRefFullName='Installation' where InvoiceLineItemRefFullName='Framing' We changed InvoiceLineItem from "Framing" to "Installation".
| |
|