Knowledgebase
[QODBC-ALL] - Troubleshooting - Excel crash when using SQL statement with two inner joins along with unoptimized
Posted by Rajendra Dewani (QODBC Support) on 21 October 2020 11:59 AM

Troubleshooting - [QODBC-ALL] - Troubleshooting - Excel crash when using SQL statement with two inner joins along with unoptimized

Problem Description

I am using Microsoft Excel.

I am using the following SQL statement.

SELECT TransferInventoryLine.TxnDate,
TransferInventoryLine.RefNumber,
TransferInventoryLine.FromInventorySiteFullName,
TransferInventoryLine.ToInventorySiteFullName,
InventorySite.SiteAddressAddr1,
InventorySite.SiteAddressAddr2,
InventorySite.SiteAddressAddr3,
InventorySite.SiteAddressAddr4,
InventorySite.SiteAddressCity,
InventorySite.SiteAddressState,
InventorySite.SiteAddressPostalCode,
InventorySite.SiteAddressCountry,
TransferInventoryLine.Memo,
TransferInventoryLine.TransferInventoryLineQuantityTransferred,
TransferInventoryLine.TransferInventoryLineItemRefFullName,
Item.Description
FROM (TransferInventoryLine unoptimized
INNER JOIN InventorySite unoptimized
ON TransferInventoryLine.ToInventorySiteListID = InventorySite.ListID)
INNER JOIN Item
ON TransferInventoryLine.TransferInventoryLineItemRefListID = Item.ListID
WHERE (TransferInventoryLine.TxnDate={d'2020-09-15'})

 

Solutions

We can reproduce the issue. The issue can be reproduced in QODBC build 336 and above.

We are working on fixing the issue.

As a workaround, please change the SQL statement.

SELECT TransferInventoryLine.TxnDate,
TransferInventoryLine.RefNumber,
TransferInventoryLine.FromInventorySiteFullName,
TransferInventoryLine.ToInventorySiteFullName,
InventorySite.SiteAddressAddr1,
InventorySite.SiteAddressAddr2,
InventorySite.SiteAddressAddr3,
InventorySite.SiteAddressAddr4,
InventorySite.SiteAddressCity,
InventorySite.SiteAddressState,
InventorySite.SiteAddressPostalCode,
InventorySite.SiteAddressCountry,
TransferInventoryLine.Memo,
TransferInventoryLine.TransferInventoryLineQuantityTransferred,
TransferInventoryLine.TransferInventoryLineItemRefFullName,
Item.Description
FROM TransferInventoryLine, InventorySite, Item
where TransferInventoryLine.ToInventorySiteListID = InventorySite.ListID
and TransferInventoryLine.TransferInventoryLineItemRefListID = Item.ListID
and TransferInventoryLine.TxnDate={d'2020-09-14'}

Click here to raise a support ticket and request if you are still facing the issue.

 

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