[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

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

193.0. "No records found (wildcards & OR)" by ILO::BROCKLEBANK () Fri Mar 31 1989 04:19

    I am running a FEX under MRE which is not finding any records. 
    The record selection expression consists of two groups of part numbers
    using wildcards to identify each group.  If I modify the FEX to
    search for either group individually, then records are found.  However,
    if I use an "OR" clause (which I take to mean records which satisfy
    either group) then no records are found.
    Any ideas on this problem would be appreciated.  I will include
    the FEX below.
    
    TABLE FILE MAXCIM
    PRINT PRTID DESCRIPT
    IF STOCKRM EQ '244' OR '249'
    IF PRTID EQ 'QA-$$$$$-$Z.$$*' OR '  -Q$$$$-$Z.$$*'
    END

T.R	Title	User	Personal Name	Date	Lines
193.1	Elucidate, my dear watson	FOOT::OTTEN	Take me to your Lizard	`Fri Mar 31 1989 05:18`	21
	Could you elaborate - I can see 4 Possible Selections eg IF PRTID EQ 'QA-$$$$$-$Z.$$' OR ' -Q$$$$-$Z.$$' IF STOCKRM EQ '244' Poss 1 Poss 2 IF STOCKRM EQ '249' Poss 3 Poss 4 If Focus uses an implicit AND Are you talking about the queries IF STOCKRM EQ '244' IF PRTID EQ 'QA-$$$$$-$Z.$$' OR ' -Q$$$$-$Z.$$' or IF STOCKRM EQ '249' IF PRTID EQ 'QA-$$$$$-$Z.$$' OR ' -Q$$$$-$Z.$$' Succeeding ?? David
193.2	Reply to 193.1	ILO::BROCKLEBANK		`Fri Mar 31 1989 09:56`	13
	Hi David, I'm talking about any records which satisfy any of the 4 possible selections. When I run the program, I get back headings but no records found. When I modify the program (leaving the STOCKRM as is) and change the PRTID selection to IF PRTID EQ 'QA-$$$$$-$Z.$$*' then records are found. I have just done some more testing and found that the program works when I invoke FOCUS outside MRE. Maybe I have some MRE setting incorrect. I'll keep this topic informed of any new developments. Regards, Dave
193.3	Solved! But Why?	ILO::BROCKLEBANK		`Fri Mar 31 1989 11:25`	8
	The PROFILE.FEX contained a SET ALL=ON . This was not invoked when the program was submitted under MRE. If I include this statement at the top of the FEX, then it runs OK, and returns the records. So the problem is solved ! But I'm not sure why. I can understand that if some part numbers have no corresponding records in the stock file why they won't be listed in the report. Why no records were listed ....? Any ideas David?
193.4	AHA - Integrator problem !	FOOT::OTTEN	Take me to your Lizard	`Fri Mar 31 1989 13:18`	10
	Have a look in the Application Pre-Processing routines - Or the User Pre-Processing assigned to this .FEX Or log a hotline, and I'll have MRE Development look at it (It'll probably be assigned to me, but........) Hotline number for MRE is 7-781-4138 David (7-781-4424)
193.5	MRE and PROFILE.FEX	YARD::OTTEN	Take me to your Lizard	`Mon Apr 03 1989 05:51`	13
	I'm wrong !...... (grovel, apologies etc...) MRE Does _NOT_ use the profile.FEX - it is used by interactive FOCUS to (for example) define keystrokes etc..... Since MRE does NOT give direct access to FOCUS, MRE never accesses the profile. So, you'll have to edit the procedure(s) to include the SET ALL=ON David