Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!gem.mps.ohio-state.edu!tut.cis.ohio-state.edu!trout.cis.ohio-state.edu!layne
From: layne@trout.cis.ohio-state.edu (eric b layne)
Newsgroups: comp.sys.mac
Subject: 4D V2 Traps
Message-ID: <65820@tut.cis.ohio-state.edu>
Date: 9 Oct 89 14:17:08 GMT
Sender: news@tut.cis.ohio-state.edu
Reply-To: eric b layne <layne@cis.ohio-state.edu>
Organization: Ohio State University Computer and Information Science
Lines: 20

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