|
| Iniciado por guest, 11,nov. 2014 20:01 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 11,noviembre 2014 - 20:01 |
Hi,
I would like to sort on a calculated item in a query.
The calculated item should be True or False based on equality of two numeric items in the query: File1.Item1=File1.Item2
I cannot find a syntax that is accepted by the query editor, neither in SQL nor in WL code.
A simple File1.Item1=File1.Item2 won't do.
I got as far as ABS(File1.Item1-File1.Item2), but I need the result to be strictly True or False.
Any ideas?
Regards,
Piet |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,noviembre 2014 - 20:16 |
Piet
Can you not use a CASE statement?
CASE WHEN File1.Item1 = File1.Item2 THEN 1 ELSE 0 END
and sort on the resulting true or false |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,noviembre 2014 - 20:34 |
| |
| |
| | | |
|
| | | | |
| | |
|