0
Array ( [0] => 120-1496395352 ) UPDATE SalesOrderLine SET SalesOrderLineItemRefListID='80000002-1496311427', SalesOrderLineQuantity =1, SalesOrderLineRate=200, SalesOrderLineItemRefFullName='Ipad', SalesOrderLineAmount=200, SalesOrderLinedesc='Ipad', CustomerRefListID='80000005-1496311377', RefNumber='9', TxnDate={d'2017-06-30'} WHERE SalesOrderLineTxnLineID='120-1496395352'

INSERT INTO SalesOrderLine ( SalesOrderLineItemRefListID, SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineItemRefFullName, SalesOrderLineAmount, SalesOrderLinedesc, CustomerRefListID, RefNumber, TxnDate ) VALUES ( '80000004-1496311430', 2, 5, 'sandwich', 10, 'sandwich description sandwich', '80000005-1496311377', '9', {d'2017-06-30'} )

I want to insert the query to the same txnid but when I put txnid it say field not required in insert

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Muhammad Rizwan
  • 3
  • 1

1 Answers1

0

If you want to insert SalesOrderLine item to an existing SalesOrder, then please refer below mentioned link for How to insert SalesOrderLine item to an existing SalesOrder:

How to insert SalesOrderLine item to an existing SalesOrder

If you are still facing the issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.

1) Screenshot of QODBC Setup Screen -- > About

2) Screenshot of the issue you’re facing.

Share Entire Log Files as an attachment in text format from

3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages

4) QODBC Setup Screen -- > Messages -- > Review SDK Messages

Jack QODBC
  • 86
  • 3