I tried creating a double list box for the following focexec, and it generated this error:

(FOC257) MISSING QUOTE MARKS: 'NE'';

TABLE FILE EMPDATA
PRINT
SALARY
BY DIV
BY DEPT
BY LASTNAME
BY FIRSTNAME
WHERE DIV EQ '&DIV';
END

My selections from the list box were CE and NE. How do I fix this, and shouldn't the control take care of writing the quotes as needed?

Thank you.

This message has been edited. Last edited by: Kerry,

No. The HTML control and the focexec need to work together. Single select dropdowns pass values like:

NE

without quotes. But multiselect controls pass values with quotes, like this:

'CE' OR 'NE'

So in your example, it should work if you remove the quotes from around the parameter.

Such an easy fix!

Thank you.