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

Problem Description:

I am getting the error "Invalid operand for the 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 an Invalid operand for operator error when you provide the wrong data type values in your query.

For Example:

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

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

Please refer to 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 to QODBC Data Layout for more details.