Conference ilbbak::ibi_focus

544.0. "CONTAINS and ON TABLE SAVE Question" by PAKORA::SACAMPBELL (Too Fast to Live, Too Young to Die !!) Fri Feb 12 1993 05:00

I've got a couple of questions I'm struggling to get an answer for so I hope you
can help.


1.  We have a procedure which uses the CONTAINS option to extract all records
    where a description contains a certain string. This string can be a mixture
    of uppercase and lowercase. CONTAINS seems to be case sensitive so hardcoding
    these values is not a problem. But we would like to be flexible and have the
    same FOCUS routine used for any string. We started passing the possible
    combinations as variables into the FEX but it looks like that no matter how
    you pass these strings FOCUS will convert them to uppercase therefore the 
    CONTAINS will not capture all records.

	Is there a workaround for this ?

2.  When using ON TABLE SAVE some of the values have no data. We have set NODATA
    to 0 but when we inpect the saved file it holds the '.' for the NODATA fields.
    Page 1-182 talks about how to preserve that missing data using
    ON TABLE SAVE AS filename MISSING ON but this does not seem to work either
    because the save file still had the '.' where there was no data.


	FOCUS version is 6.1.0


Any suggestion gratefully received.


Thanx,

	Stuart.

    
    	1.  One option might be to take the field you are testing on,
    	convert it all to upper or lower case and just test on those all
        upper and lower functions - see subroutine library for function.
    
        2.  Have you tried instead of saving the file, hold it in a
        different format like DOC ???
    
    	Some thoughts,
    	LisaC