Not sure what to say. It works for me.
I used the following template (same as above)
Code:
program:
test(
and(
strcmp(field('#keep_read'), 'yes', '', 1, ''),
strcmp(field('#read_status'), 'N', '', 1, '')
),
'Yes',
'No');
and these column definitions:
The next screen capture shows the input data and the result. There is exactly one "Y", which is the correct answer (as far as I know).
---
For completeness I also tried it with #keep_read as a text column with the following definition.
The following screen capture shows that the template still works.
---
All I can suggest is that you check that:
- you didn't change the template
- the column definitions are the same as mine
- the data is as you described (the same as mine).
This test template might help you work out where things are going wrong. It shows the result of the two strcmp functions.
Code:
program:
strcat(
'keep_read strcmp returns "',
strcmp(field('#keep_read'), 'yes', '', 1, ''),
'", read_status strcmp returns "',
strcmp(field('#read_status'), 'N', '', 1, ''),
'"')