Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - VB Demo is crashing when using nonexisting column name in left outer join query
Posted by Jack - QODBC Support on 24 November 2016 11:23 AM

Troubleshooting - VB Demo is crashing when using the non-existing column name in the left outer join query

Note: VB Demo is deprecated.

Please refer to How to use the QODBC Test Tool for testing

Problem Description:

I am executing the below query in VB Demo. But VB Demo is crashing at the time of execution. I have checked the same query in MS Access & noticed that I accidentally typed the wrong column name in the join query. But MS Access does not crash. Only VB Demo hits.

SELECT
PriceLevel.Name,
PriceLevelPerItem.Name,
PriceLevelPerItem.PriceLevelPerItemItemRefFullName,
PriceLevelPerItem.PriceLevelPerItemCustomPrice
FROM PriceLevel
LEFT OUTER JOIN PriceLevelPerItem left outer join item ON PriceLevel.l ListID on PriceLevelPerItem. isted = PriceLevelPerItem.ItemRefListID=item.listid
WHERE
(PriceLevelPerItem.PriceLevelPerItemItemRefListID=item.listed or PriceLevelPerItem.PriceLevelPerItemItemRefListID is null) and item.FullName = 'Installation Labor'

 

Solution:

Due to this VB Demo crashing, your query has no space before "FROM" and back to "LEFT." Please add a space before "FROM" and before "LEFT" in question & test again VB Demo will not crash. Also, correct the wrong column name in the query & test furthermore.

SELECT
PriceLevel.Name,
PriceLevelPerItem.Name,
PriceLevelPerItem.PriceLevelPerItemItemRefFullName,
PriceLevelPerItem.PriceLevelPerItemCustomPrice FROM PriceLevel
LEFT OUTER JOIN PriceLevelPerItem left outer join item ON PriceLevel.ListID = PriceLevelPerItem.ListID on PriceLevelPerItem.PriceLevelPerItemItemRefListID=item.listid
WHERE
(PriceLevelPerItem.PriceLevelPerItemItemRefListID=item.listid or PriceLevelPerItem.PriceLevelPerItemItemRefListID is null) and item.FullName = 'Installation Labor'

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