| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I am getting some different results with "IF" statements in FOCUS,
when the file is a RDB file accessed by FOCUS or when the file is
a FOCUS file accessed by FOCUS. The conditions are listed below
has anybody had any similar results or solutions?
The field in both files is described the same Fieldname = PART
Format = A15.
IF PART EQ '00-Q$00$-$$4.7' worked in focus file
IF PART EQ '00-Q$00$-$$4.7' does not work in RDB file
IF PART EQ '00-Q$00$-$$4.7' OR '00-Q$00$-4.7A' worked in RDB file
IF PART EQ '00-Q$00$-$$4.7 ' worked in focus file
IF PART EQ '00-Q$00$-$$4.7 ' does not work in RDB file
IF PART EQ '00-Q$00$-$$4.7$' worked in focus file
IF PART EQ '00-Q$00$-$$4.7$' worked in RDB file
These part numbers do exist in both files but the selection criteria
does not work the same in both files.
Thanks
Dave White
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 54.1 | See descr. extern. file: USAGE & ACTUAL | PRSEIS::EMILE | Thu Jun 16 1988 05:04 | 16 | |
The problem may come from how you describe the external file...
Can you give me more information about "does not work..."?
Please send '.MAS' of the two files.
Any way, problem may be solved with USAGE or ACTUAL attributes.
ACTUAL describe the format of the field in external files...
(RdB for example).
USAGE describe how the data should be used within FOCUS.
(See Describing external files...).
Good luck,
Emile,
| |||||