Focal Point
[SOLVED] Filter unique records

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8421086013

December 16, 2008, 05:45 AM
Anant
[SOLVED] Filter unique records
Hello,

I want to convert the following statement in WebFocus reporting language:

SELECT DISTINCT DEPT FROM DEPARTMENT;

What code should I write?

WebFocus 711 on Windows NT

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


Regards,
Anant

WebFOCUS 7
Windows
Output: Excel, PDF, HTML
December 16, 2008, 06:14 AM
Anoop
Do you have a MFD created for this table?

try this

TABLE FILE DEPARTMENT
PRINT
DST.DEPT
END


WebFOCUS 7.0.4
Windows XP
HTML
PDF
EXCEL
December 16, 2008, 07:07 AM
Anant
thanks a lot...


Regards,
Anant

WebFOCUS 7
Windows
Output: Excel, PDF, HTML