Search results for query: *

Hi, I have a query like the following: TABLE FILE PROJECTS PRINT PROJECT_NUMBER WHERE PROJECT_NUMBER EQ '1234' WHERE (STAT_CD NE '201') END Suppose there is one record in table PROJECTS where PROJECT_NUMBER = '1234', and STAT_CD is NULL for that record. The above query will not qualify the...

Craigiep, I need the hold file to look like this: 2002 2003 First half 2004 Second half 2004 2005 2006 ... So one of the records from the table (2004) needs to be split off into 2 different records, and all the others stay as they are. Thanks, Sean

I have a file called YEARS containing unique years: 2002, 2003, 2004, ..., 2010. I would like to store the years in a hold file, with one exception. For the current year only (2004), I want to write 2 different records to the hold file: 'First half 2004', and 'Second half 2004'. I looked into...

OK, I got it. I needed to reformat the date to an integer string... -SET &TMP_DT = EDIT(&DATEYYMD, '9999$99$99'); -SET &FMT_DT = CHGDAT('YYMD', 'DMYYT', &TMP_DT, 'A17'); -TYPE formatted date: { &FMT_DT } now gives.... current date: 2004/04/20 formatted date: { 20 APR 2004 }

Is there a way to get the CHGDAT function to work in DM? I am using WebFocus v4.3.6. When I try the following syntax, I don't get the anticipated output.... -TYPE current date: &DATEYYMD -SET &FMT_DT = CHGDAT('YYMD', 'DMYYT', &DATEYYMD, 'A17'); -TYPE formatted date: { &FMT_DT } gives me...

OK, thanks gizzy!

When I try TABLASTPAGE, I get the error (FOC406) THE FIELDNAME IS NOT RECOGNIZED: TABLASTPAGE Here is a snippit of how I am using it... FOOTING &quot;Page <TABLASTPAGE&quot; I am using WF version 4.3.6. Has TABLASTPAGE been added in a version more recent than that one? Thanks, Sean

Is there a WF variable that stores the total number of pages in a report? TABPAGENO provides the current page number, but I would like to display something like 'Page x of y' where y is the number of pages in the report. Thanks, Sean

kiddpete, Ok, thanks for the info!

Thanks for the reply kiddpete! Ideally, I would like to be able to do this within a DEFINE FILE. I looked at POSIT, but it appears to me that I can only find the position of the first occurrence, so that was a non-starter. So I have been unsure whether this can be accomplished using POSIT or...

Matthew, I have encountered problems when the label reference of the GOTO is greater than 12 characters long. So shorten your INVALIDACCOUNT label to 12 chars or less. Regards, Sean

Hi, Is there a mechanism/function in WebFocus to substitute all occurrences of a character to a string? I know that CTRAN can replace a character 1-for-1, but I want to replace one character with 2 characters. Specifically, I want to replace all occurrences of double-quote for backslash plus...