Knowledgebase: Tutorials
[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 InvoiceLineItemRefFullName2

Problem:

How do I replace all invoices containing the InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation."

First, we will fetch data from the InvoiceLine table whose InvoiceLineItemRefFullName is "Framing":

By Querying:

Select TxnID,TxnDate,RefNumber,InvoiceLineItemRefListID,InvoiceLineItemRefFullName from InvoiceLine where InvoiceLineItemRefFullName='Framing'

 

Note: Invoice has different TxnID, TxnDate & RefNumber.

Solution:

By executing the below update statement in QODBC Test Tool, We can change InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation."

Update InvoiceLine set InvoiceLineItemRefFullName='Installation' where InvoiceLineItemRefFullName='Framing'

We changed InvoiceLineItem from "Framing" to "Installation."

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).