Knowledgebase
[QODBC-Desktop] Troubleshooting - [QODBC] Invalid operand for operator: <assignment>
Posted by Jack - QODBC Support on 19 January 2016 10:31 AM

Troubleshooting - [QODBC] Invalid operand for operator: <assignment>

Problem Description:

I am getting the error "Invalid operand for operator: <assignment>" while trying to insert an invoice line item:

INSERT INTO InvoiceLine ( CustomerRefListID, TemplateRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineRate, InvoiceLineAmount, InvoiceLineTaxCodeRefListID, FQSaveToCache) VALUES ( '800019E1-1428688811', '8000001B-1360624407', '17003', '80000129-1362767268', 65.0000, '130.00', '80000002-1358615111', 0)

 

Solution:

You will get Invalid operand for operator error when you provide wrong data type values in your query.

For Example:

Column data type is decimal/integer/bit & you are inserting value as string/character.

In your query InvoiceLineAmount column data type is decimal & you provided value as string/character.

Please refer below sample query & test again:

INSERT INTO InvoiceLine ( CustomerRefListID, TemplateRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineRate, InvoiceLineAmount, InvoiceLineTaxCodeRefListID, FQSaveToCache) VALUES ( '800019E1-1428688811', '8000001B-1360624407', '17003', '80000129-1362767268', 65.0000, 130.00, '80000002-1358615111', 0)

Please refer QODBC Data Layout for more details.

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