1
General Board / Re: Sql to get its info from fields of a model element
« on: Today at 03:00:21 am »
because the value 0.2 is not equal to the value '0.2','0.3'
If you wanted the "in" to work, you would need to have multiple element with name 'special info' where each of them has a single possible value. e.g.
- 0.2
- 0.3
SQL will not parse and evaluate the string that is returned by the subquery; it tests if it matches one of the returned strings exactly; and in this case it doesn't.
Geert
If you wanted the "in" to work, you would need to have multiple element with name 'special info' where each of them has a single possible value. e.g.
- 0.2
- 0.3
SQL will not parse and evaluate the string that is returned by the subquery; it tests if it matches one of the returned strings exactly; and in this case it doesn't.
Geert