Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!gem.mps.ohio-state.edu!tut.cis.ohio-state.edu!ucbvax!agate!shelby!lindy!liemandt
From: liemandt@lindy.Stanford.EDU (Joe Liemandt)
Newsgroups: comp.sys.mac
Subject: Re: 4D V2 Traps
Message-ID: <5090@lindy.Stanford.EDU>
Date: 10 Oct 89 02:52:01 GMT
References: <65820@tut.cis.ohio-state.edu>
Sender: liemandt@lindy.Stanford.EDU (Joe Liemandt)
Reply-To: liemandt@lindy.Stanford.EDU (Joe Liemandt)
Organization: Stanford University
Lines: 51

In article <65820@tut.cis.ohio-state.edu> eric b layne <layne@cis.ohio-state.edu> writes:
>Search by layout is a great new feature in version 2 of 4th dimension
>However, you have to be carefull when using '#' sign in your fields.
>
>Eg.
> 
>I was tring to do a search by layout for a department called #3 Zinc Grip.
>I typed #3 Zinc Grip into the department field, so it should give me all
>of the entries in that department Right?....WRONG!
>It gave me all of the entries.  When I looked at the search by formula
>screen it said
>
>Department          is not equal to           3 Zinc Grip
>
>Obviously it took the # to mean 'not equal to' and since I didn't have any
>departments call '3 Zinc Grip', It gave me all the records.
>
>There are two ways to get around this problem.  Either use No. for the # sign,
>or don't use search by layout, (make your own search dialog using variables).
>
>--Eric Layne

There is another way around the problem.  4D looks at the first
character in the seach by layout field.  If it is a comparison
operator, it uses that for the comparison, it then takes the rest of
the string as the criterion.  If no operater is given it defaults to
"=".  

So, to search for the string "#3 Zinc Grip"  You would enter the string

    =#3 Zinc Grip

This will find all #3 Zinc Grips.


Joe Liemandt
liemandt@lindy.stanford.edu

L
O
T
S

OF

F
I
L
L
E
R