Knowledgebase
[QODBC Online] How to insert data into the VendorCredit table
Posted by Rajendra Dewani (QODBC Support) on 14 December 2022 02:36 PM

[QODBC Online] How to insert data into the VendorCredit table

Problem Description:

How to insert data into the VendorCredit table

Solution: 

 

Open the "QODBC Online Test tool" from the start menu.

 

Click on the "Connect" button.

 

Used the below SQL statement to insert data into the VendorCredit table

INSERT INTO "VendorCredit" ("VendorRefListID", "APAccountRefListID", "TxnDate", "RefNumber", "Memo") VALUES ('90000-933272656', 'C0000-933270541', {d'2003-12-15'}, '1', 'Memo Test')

 

 

 

(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).