Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] MISSING QUOTE MARKS error from double list box
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] MISSING QUOTE MARKS error from double list box
 Login/Join
 
Platinum Member
posted
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,


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
 
Posts: 100 | Registered: September 15, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 158 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Such an easy fix!

Thank you.


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
 
Posts: 100 | Registered: September 15, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] MISSING QUOTE MARKS error from double list box

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.