Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - How do I update Customer custom fields
Posted by Jack - QODBC Support on 11 April 2016 12:00 PM

Troubleshooting - How do I update Customer custom fields

Problem Description:

How do I update Customer custom fields? 

Solution:

You can update Customer custom fields using the update query.

For Example:
Update Customer Set CustomFieldContract='QODBCJOB1' where ListID='800000F2-1513344011'


And there you have it! To check that everything actually worked just do:
Select ListID, Name, FullName, CustomFieldContract from Customer where ListID='800000F2-1513344011'


You can check it on QuickBooks also.


You can insert Custom fields during Customer creation also. Please refer below sample query for the same.

INSERT INTO "customer" ("Name","LastName","FirstName","BillAddressAddr1","BillAddressAddr2","BillAddressCity", "BillAddressState","BillAddressPostalcode","CustomFieldBDay","CustomFieldContract","CustomFieldSpousesName") values('Juniga, Daphne','Juniga','Daphne','Daphne Juniga','561 W 4th St.','Carlsbad','CA','92009', '26/01/1987', 'QODBCJOB1','Jack')


And there you have it! To check that everything actually worked just do:
Select Name, CustomFieldBDay,CustomFieldContract,CustomFieldSpousesName from Customer where Name='Juniga, Daphne'


You can check it on QuickBooks also.

 

 

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