Search results for query: *

I'm working with a legacy application (version 7.1.4) Is there a way to reference the value of a drop down box in an html form from a webfocus executable (fex)? For example: -SET &MYVAR='function getVal()' Thanks.

Found a way to make it work. TABLE FILE BPDNEW PRINT TOT.ACCTS TOT.BPDLDA WHERE CHKDATE GE &RDATE AND CHKDATE LE &TODATE; WHERE BPDDTE EQ &CHKBILL; WHERE BPDCLB EQ &CLUBID; WHERE BPDCOL EQ 'Y'; WHERE BPDPCH EQ ' '; WHERE BPDSTC EQ 'RFC'; WHERE MYDATE GE CHKDATE AND...

Here's a code snippet of what I have so far: JOIN BPDCLB AND BPDMBR IN BPDNEW TO CRCLB AND CRMBR IN CRFILL20 AS J4 END DEFINE FILE BPDNEW ACCTS/I5CS =1; CHKDATE/YMD =BPDSTD; MYDATE/YMD =DATECVT(CRDTE,'I6MDY','YMD'); END TABLE FILE BPDNEW SUM ACCTS BPDCBA WHERE CHKDATE GE &RDATE AND...

Okay, I see what you're saying. I'll verify the datasource content and I'll find a way to determine how many records I'm actually getting from the selection criteria. If I'm getting a cartesian product then I'll have to determine how to resolve that. Thanks focwizard, I just needed a bump in the...

The entire record is being duplicated. The parent instance does have multiple children in one child. I expect to see one combined record, the join matches the 'range' of records and the where clause selecting the dates should extract one record from the parent and one record from the child. I've...

New to webfocus. Using DB2 adapter for IBM 550. Following code produces duplicates with some date ranges. Suggestions? JOIN BPDCLB AND BPDMBR IN BPDNEW TO BIFCLB AND BIFMBR IN BIFIL AS J0 END JOIN BPDCLB AND BPDMBR IN BPDNEW TO CRCLB AND CRMBR IN CRFILL08 AS J1 END DEFINE FILE BPDNEW...