Focal Point
FOCLIST suppression

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

March 20, 2007, 11:01 AM
FrankDutch
FOCLIST suppression
Hi Guru's

Is it possible to prefend the creation of the field FOCLIST when I create an HOLDFILE FORMAT FOCUS

Frank




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

March 20, 2007, 11:03 AM
Francis Mariani
You get a FOCLIST field to create a unique key when using PRINT and not SUM when creating a FOCUS DB.

Use SUM and appropriate BY statements.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 20, 2007, 11:27 AM
FrankDutch
ok

that helps a lot Francis

(I thought this answer could be given by a guru, but the virtuoso was quicker....)

Frank




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7