SQL query WHERE column = property value (string)

Ignition
1

Hi guys,

Can someone tell me why I can execute this SQL query:

SELECT vsf_grades.designator
FROM vsf_products INNER JOIN (vsf_grades INNER JOIN vsf_grade_products ON vsf_grades.db_id = vsf_grade_products.vsf_grades_db_id) ON vsf_products.db_id = vsf_grade_products.vsf_products_db_id
WHERE (((vsf_products.designator)='product1'));

And not this one:

SELECT vsf_grades.designator
FROM vsf_products INNER JOIN (vsf_grades INNER JOIN vsf_grade_products ON vsf_grades.db_id = vsf_grade_products.vsf_grades_db_id) ON vsf_products.db_id = vsf_grade_products.vsf_products_db_id
WHERE (((vsf_products.designator)={Root Container.Dropdown 3.selectedStringValue}));

btw {Root Container.Dropdown 3.selectedStringValue} = 'product1'

Regards,

D.Botha

2

Add the quotes outside the curly braces.

1 Like