Where Syntax
Dear all,
I red a few lists, did some search and looks like my error appeared a few times (Barteder Error #3239) but in fact there was no case similar to mine. To be more precise: suggested solutions do not work.
The issue is as follows (Bartender 9.4):
1. 'FO_Production plan - SN BN.xlsm' file is a data source for BT label.
2. On BT label level I want to filter range of data from sheet called 'SN & BN plan' by using custom SQL query statement. To be more precize: I am interested in only those data which value is > 0
3. I wrote the following SQL query:
--
SELECT * FROM `'SN & BN plan$'_xlnm#_FilterDatabase` WHERE 'Manufactured quantity' > 0
--
Having wrote as above, the BT gives me an error 3239. What is wrong?
I red a few lists, did some search and looks like my error appeared a few times (Barteder Error #3239) but in fact there was no case similar to mine. To be more precise: suggested solutions do not work.
The issue is as follows (Bartender 9.4):
1. 'FO_Production plan - SN BN.xlsm' file is a data source for BT label.
2. On BT label level I want to filter range of data from sheet called 'SN & BN plan' by using custom SQL query statement. To be more precize: I am interested in only those data which value is > 0
3. I wrote the following SQL query:
--
SELECT * FROM `'SN & BN plan$'_xlnm#_FilterDatabase` WHERE 'Manufactured quantity' > 0
--
Having wrote as above, the BT gives me an error 3239. What is wrong?
0
-
Hi again,
Sorry for above question! Sometimes to get answer it is usefull to write the question...
Just as a feedback - I found my mistake. FYI:
The correct syntax in my case should be as follows (a bit different type of brackets should be used):
SELECT * FROM `'SN & BN plan$'_xlnm#_FilterDatabase` WHERE `Manufactured quantity` > 0
Small things makes a difference
BR
Wojciech0 -
Yes SQL is very particular about the type and placement of quote marks.
My advice in general is that you use the query builder as much, or as close as possible to what you want, and then activate the custom SQL checkbox to make final modifications. In this way the correct syntax is already laid out for you making it less likely to make a mistake in this regard.0
Please sign in to leave a comment.
Comments
2 comments