Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting - Getting Error [QODBC] Requires at least one child. Cannot delete last line
Posted by Jack - QODBC Support on 13 December 2016 06:40 AM

Troubleshooting - Getting Error [QODBC] Requires at least one child. I cannot delete the last line

Problem Description:

I entered a series of purchase orders with queries that look like this:

INSERT INTO PurchaseOrderLine ("VendorRefListID", "RefNumber","PurchaseOrderLineItemRefListID", "PurchaseOrderLineDesc", "PurchaseOrderLineQuantity", "PurchaseOrderLineRate", "PurchaseOrderLineAmount", "FQSaveToCache") VALUES ('8000002F-1480957977', '1485', '800002C0-1480957977', '50-pc briquette set for hp 94751', 500, 8.00, 4000.00, 0);

I ran queries for c. 400 line items for 48 po's.

This resulted in two distinct po's for each PO number, twice as many line items as I had intended.

I first thought to start over and try again. To that end, I ran this:

Delete FROM PurchaseOrderLine where TxnID='2770-1071519624'



ERROR: [QODBC] Requires at least one child. I cannot delete the last line. This results in this error: This results in this error: This results in this error:

 

So, I'm out of ideas.

Please tell me how to get rid of the duplicates. 

Solution:

You have only one line item in a PurchaseOrderLine table for that particular TxnId. You cannot use the last line item, which is associated with the header row of PurchaseOrder. You cannot delete the previous line.

You need to delete the header row from the PurchaseOrder table, So please try to delete the row for that particular TxnID from the PurchaseOrder table. Please verify the same & try again.

Please refer to the sample query & check again.

For Example:

Delete FROM PurchaseOrder where TxnID='2770-1071519624'

 

 

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