I have a parameter set up for my date field - NEWDATE. I keep getting the error - FOC205 THE description cannot be found for file named: Dump. Any ideas on how to fix?

This is don off of the GUI 7.6.

Code below:

DEFINE FILE TBLARCH
NEWDATE/HMDYY=NOM_DATE;
END
TABLE FILE TBLARCH
SUM
FULLNAME
TEAMNAME
EMP_SHORT_NAME
NEWDATE
START
SCHEDULED
SIGNED_IN
COMPLIANCE
STOP
BY LUCENT
ON TABLE NOTOTAL
ON TABLE HOLD AS DUMP
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=8.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=8.000000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=8.000000,
$
ENDSTYLE
END
DEFINE FILE DUMP ADD
NUMSEC/I4=START;
HOUR/I2=(NUMSEC/60);
MIN/I2=((NUMSEC/60 - (HOUR *60)));
HHMMSS/I6=INT( NUMSEC/3600 ) * 10000 + INT( IMOD(NUMSEC,3600,'I4')/60 ) * 100 + IMOD(NUMSEC,60,'I2');
TIME/A9=IF START LT 0 THEN '-' | EDIT(HHMMSS,'99:99:99') ELSE EDIT(HHMMSS,'99:99:99');
SNUMSEC/I4=STOP;
SHOUR/I2=(SNUMSEC/60);
SMIN/I2=((SNUMSEC/60 - (SHOUR *60)));
SHHMMSS/I6=INT( SNUMSEC/3600 ) * 10000 + INT( IMOD(SNUMSEC,3600,'I4')/60 ) * 100 + IMOD(SNUMSEC,60,'I2');
STIME/A9=IF STOP LT 0 THEN '-' | EDIT(SHHMMSS,'99:99:99') ELSE EDIT(SHHMMSS,'99:99:99');
DNUMSEC/I4=SCHEDULED;
DHOUR/I2=(DNUMSEC/60);
DMIN/I2=((DNUMSEC/60 - (DHOUR *60)));
DHHMMSS/I6=INT( DNUMSEC/3600 ) * 10000 + INT( IMOD(DNUMSEC,3600,'I4')/60 ) * 100 + IMOD(DNUMSEC,60,'I2');
DTIME/A9=EDIT(DHHMMSS,'99:99:99');
END
TABLE FILE DUMP
SUM
START NOPRINT
TIME AS 'START'
STOP NOPRINT
STIME AS 'STOP'
SCHEDULED NOPRINT
DTIME AS 'SCHEDULED'
COMPUTE SIGN/D5.1% = ( SIGNED_IN / SCHEDULED ) * 100; AS 'SIGN IN %'
COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100;
AS 'COMPLIANCE %'
BY TOTAL HIGHEST COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100; NOPRINT
BY EMP_SHORT_NAME AS 'FSC Name'
ON TABLE SUBHEAD
"Weekly Adherence Report"
" "
"WHERE ( TEAMNAME EQ '&TEAMNAME.(FIND TEAMNAME IN tblarch).Please Select Team.' ) AND ( NEWDATE EQ DT(&NEWDATE.(FIND NEWDATE IN dump).NEWDATE.) );
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE DUMP.DUMP.START DUMP.DUMP.STOP DUMP.DUMP.SCHEDULED SIGN COMPPER AS 'ROLL-UP'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=( RGB(234 234 255) 'WHITE' ),
$
TYPE=DATA,
COLUMN=N2,
FOCEXEC=v1adhere(Name=N2),
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
SIZE=9,
COLOR='WHITE',
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=9,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='TAHOMA',
SIZE=18,
COLOR=RGB(73 19 236),
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
FONT='TAHOMA',
SIZE=12,
COLOR='RED',
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
FONT='TAHOMA',
SIZE=12,
COLOR='RED',
$
TYPE=TABFOOTING,
SIZE=9,
STYLE=BOLD,
$
TYPE=HEADING,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
SIZE=12,
COLOR='WHITE',
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
SIZE=14,
$
TYPE=FOOTING,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
COLOR='WHITE',
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=9,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
SIZE=9,
COLOR='WHITE',
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=SUBTOTAL,
SIZE=8,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
SIZE=8,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
BACKCOLOR=RGB(234 234 255),
$
TYPE=ACROSSTITLE,
SIZE=8,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
COLOR='WHITE',
BACKCOLOR='GRAY',
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N0,
WRAP=8.000000,
$
ENDSTYLE
END

WebFocus 7.7.02 WinXP

Something is happening in your first request, the one that creates the DUMP file, that is causing it not to get created. That is why you are getting the error.

Now you need to figure out why the first request is failing. Got anymore error messages for us to look at?

quote:

STOP

Is that a reserved word?

Joe

To debug your script start with adding

-SET &ECHO=ALL;

in the first part, where you create the hold file, remove all the stuff that does the styling.

After the first end add

? HOLD DUMP
EXIT

If this does work, the problem will probably be in the define part.

quote:

NOM_DATE

what is the original format of this field?

Frank,
The master file has the format as HYYMDI. I'm re defining it as mm/dd/yy

I'll also try your other suggestion.

Thanks!

Part of my original request go cut off.

Here is the code again: The error seems to be in the where clause for NEWDATE. When I take that where statement out it works.

DEFINE FILE TBLARCH
NEWDATE/HMDYY=NOM_DATE;
END
TABLE FILE TBLARCH
SUM
FULLNAME
TEAMNAME
EMP_SHORT_NAME
NEWDATE
START
SCHEDULED
SIGNED_IN
COMPLIANCE
STOP
BY LUCENT
ON TABLE NOTOTAL
ON TABLE HOLD AS DUMP
END
DEFINE FILE DUMP ADD
NUMSEC/I4=START;
HOUR/I2=(NUMSEC/60);
MIN/I2=((NUMSEC/60 - (HOUR *60)));
HHMMSS/I6=INT( NUMSEC/3600 ) * 10000 + INT( IMOD(NUMSEC,3600,'I4')/60 ) * 100 + IMOD(NUMSEC,60,'I2');
TIME/A9=IF START LT 0 THEN '-' | EDIT(HHMMSS,'99:99:99') ELSE EDIT(HHMMSS,'99:99:99');
SNUMSEC/I4=STOP;
SHOUR/I2=(SNUMSEC/60);
SMIN/I2=((SNUMSEC/60 - (SHOUR *60)));
SHHMMSS/I6=INT( SNUMSEC/3600 ) * 10000 + INT( IMOD(SNUMSEC,3600,'I4')/60 ) * 100 + IMOD(SNUMSEC,60,'I2');
STIME/A9=IF STOP LT 0 THEN '-' | EDIT(SHHMMSS,'99:99:99') ELSE EDIT(SHHMMSS,'99:99:99');
DNUMSEC/I4=SCHEDULED;
DHOUR/I2=(DNUMSEC/60);
DMIN/I2=((DNUMSEC/60 - (DHOUR *60)));
DHHMMSS/I6=INT( DNUMSEC/3600 ) * 10000 + INT( IMOD(DNUMSEC,3600,'I4')/60 ) * 100 + IMOD(DNUMSEC,60,'I2');
DTIME/A9=EDIT(DHHMMSS,'99:99:99');
END
TABLE FILE DUMP
SUM
START NOPRINT
TIME AS 'START'
STOP NOPRINT
STIME AS 'STOP'
SCHEDULED NOPRINT
DTIME AS 'SCHEDULED'
COMPUTE SIGN/D5.1% = ( SIGNED_IN / SCHEDULED ) * 100; AS 'SIGN IN %'
COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100;
AS 'COMPLIANCE %'
BY TOTAL HIGHEST COMPUTE COMPPER/D5.1% = ( COMPLIANCE / SCHEDULED ) * 100; NOPRINT
BY EMP_SHORT_NAME AS 'FSC Name'
ON TABLE SUBHEAD
"Weekly Adherence Report"
" "
"WHERE ( TEAMNAME EQ '&TEAMNAME.(FIND TEAMNAME IN tblarch).Please Select Team.' );
WHERE NEWDATE EQ DT(&NEWDATE.(FIND NEWDATE IN DUMP).Select Date:.);
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE DUMP.DUMP.START DUMP.DUMP.STOP DUMP.DUMP.SCHEDULED SIGN COMPPER AS 'ROLL-UP'
END

WebFocus 7.7.02 WinXP

Second part of code that got cut off again:

WHERE ( TEAMNAME EQ '&TEAMNAME.(FIND TEAMNAME IN tblarch).Please Select Team.' );
WHERE NEWDATE EQ DT(&NEWDATE.(FIND NEWDATE IN DUMP).Select Date:.);
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE DUMP.DUMP.START DUMP.DUMP.STOP DUMP.DUMP.SCHEDULED SIGN COMPPER AS 'ROLL-UP'
END

Frank,

I tried your check scrip suggestion and it did not work.

Thanks for your suggestion.

quote:

HYYMDI

Joe

I think your problem is the date format in the first define
I'm not sure if you can convert a HYYMDI format date field the way you do this.
I think this is an alpha format date time field.

How does this field look if you print one?

Is it a long string like '20080112133059888999'?

If so you need an other formula that first convert this form alpha and then into a real date and time value.

I do not know these formulas without the manual.

Is it not possible to just use the nom_date as it is in your database?

If I do not format the Nom_Date field, it is printed as 2007/12/03 00:00. When I format it and do not use it as a parameter, I can see it as 12/03/2007 in print. I guess what I do not understand is why does it not allow me to use the new formatted date field as a parameter. This needs to be set as a parameter for reporting purposes. The original data source is off a sequel server table in which the date field in question is formatted as 12/03/2007. When I link this table to focus it changes it to the 2007/12/03 00:00 format. I do not understand why the format changed from sequel to FOCUS? Pls help

Thanks!

Joe

try this formula

DEFINE FILE TBLARCH
NEWDATE/YYMD=HDATE(NOM_DATE,'YYMD');
END

According to your last reply I think this should work.

Test the formula first by running it!

Thanks!

I'll try it in a bit and let you know how it works.

Joe

The way I read this is that this where statement uses a &variable to populate the equation.
That &variable uses the dump file.
Which has not yet been created at the time the request is syntax checked.
Please put a -RUN after the first table request (the one that creates DUMP).
This will force the creation of the file BEFORE syntax checking the rest of the code.

Hope this helps.

Thanks!

I put the -Run command and it still came back with a (FOC003) Error can not find Field name NEWDATE.

Code to the -Run command.
DEFINE FILE TBLARCH
NEWDATE/YYMD=HDATE(NOM_DATE, 'YYMD');
END
TABLE FILE TBLARCH
SUM
START
SCHEDULED
SIGNED_IN
COMPLIANCE
STOP
FULLNAME
TEAMNAME
EMP_SHORT_NAME
NEWDATE
BY LUCENT
ON TABLE NOTOTAL
ON TABLE HOLD AS DUMP
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=8.000000,
$
ENDSTYLE
END
-Run

-RUN should be in upper case

If that doesn't work, why don't you shorten your query and see where it went wrong.

DEFINE FILE TBLARCH
NEWDATE/YYMD=HDATE(NOM_DATE, 'YYMD');
END
TABLE FILE TBLARCH
PRINT START STOP NEWDATE
END

Does that error out or does that actually provide an answer set?

It works fine in the print stage. But as soon as I add a where clause it goes goofy telling me the FOC003 message that it can not find newdate.

DEFINE FILE TBLARCH
NEWDATE/YYMD=HDATE(NOM_DATE, 'YYMD');
END
TABLE FILE TBLARCH
WHERE NEWDATE NE '&NEWDATE.(FIND NEWDATE IN TBLARCH).Date.';
PRINT
START
STOP
NEWDATE
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END

If you right-click and view source on the page that gives you the error, you might see if you have an error related to your define for NEWDATE. Fix that and your problem might go away.

Also during debugging print both NEWDATE and NOM_DATE till NEWDATE looks like it is supposed to then add the WHERE clause.

Also, you might want to take the quotes off &NEWDATE. The field NEWDATE is a smart date and by definition numeric.

Joe

try this also and see what you get

DEFINE FILE TBLARCH
NEWDATE/YYMD=HDATE(NOM_DATE, 'YYMD');
END
TABLE FILE TBLARCH
PRINT START STOP NEWDATE NOM_DATE
WHERE RECORDLIMIT EQ 5
END

This should give you the first 5 records.

Please show us these records (between [ code] [/code]) to make it better readable.

and maybe show us the master file.

The print works fine. Here's an example of the data that prints:

PAGE 1

START STOP NEWDATE
-11,040.00 2,880.00 12/17/2007
10,920.00 -60.00 12/26/2007
-720.00 420.00 12/26/2007
-60.00 .00 12/17/2007
900.00 180.00 01/03/2008

I made the date display as MDYY. Now, when I use the GUI's where function to make NEWDATE a variable field for parameter web querying I receive three error's:
0 error at or near line 6 in Procedure adhocrq;
(FOC003) - NEWDATE not recognized.

Code:

DEFINE FILE TBLARCH
NEWDATE/MDYY=HDATE(NOM_DATE, 'MDYY');
END
TABLE FILE TBLARCH
WHERE NEWDATE NE '&NEWDATE.(FIND NEWDATE IN TBLARCH).Date.';
PRINT
START
STOP
NEWDATE
WHERE RECORDLIMIT EQ 5
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END

Thanks for any help.

Joe,

Your problem is that NEWDATE only exists in the define within your program. When the FIND is executed it doesn't use the define within your program so you would be better off having the NEWDATE specified within your master file OR your could perform a table of TBLARCH post define to provide all the dates, something like this -

DEFINE FILE TBLARCH
NEWDATE/MDYY=HDATE(NOM_DATE, 'MDYY');
END
TABLE FILE TBLARCH
  BY NEWDATE
ON TABLE HOLD AS MYDATES
END
-RUN
TABLE FILE TBLARCH
WHERE NEWDATE NE '&NEWDATE.(FIND NEWDATE IN MYDATES).Date.';
PRINT START
      STOP
      NEWDATE
WHERE RECORDLIMIT EQ 5
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END

T

If I'm correct in assuming that you have autoprompt enabled, then this field NEWDATE is very much unknown at the time it is being referenced. That also explains why -RUN's doe not seem to have any effect.
Since it concerns an unknown variable, it will be asked for by the autoprompt facility.
But this facility does not know of the define, will not execute it, and concerns itself only with the master file.
As far as I can see, there is just one way around this and that is to put the define into your master file. That way the autoprompt facility will recognize the field.
If you disable the autoprompt facility, you will receive another message, stating that &NEWDATE is missing, so that is not a workaround, unless you provide another means of populating the variable, possibly using a self-created html-file.

Hope this helps.

Gamp,

Your right, I'm using the autoprompt. I'll create my HTLM page and test it by that means. I'll keep you posted.

Just an Update:
I ended up Redefining this Date field in the Master file and I got it to work. Thanks for all of your help.