layne@iris.cis.ohio-state.edu (eric b layne) (09/29/89)
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
SEWALL@UCONNVM.BITNET (Murph Sewall) (09/29/89)
On Thu, 28 Sep 89 17:56:48 GMT you said: >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. 4th Dimension is a MACintosh program (unless I missed something lately). The comment belongs on info-mac@Sumex-AIM.Stanford.Edu, does it not? I wish people wouldn't post blind into lists they've never read. Murph Sewall Vaporware? ---> [Gary Larson returns 1/1/90] Prof. of Marketing Sewall@UConnVM.BITNET Business School sewall%uconnvm.bitnet@cunyvm.cuny.edu [INTERNET] U of Connecticut {psuvax1 or mcvax }!UCONNVM.BITNET!SEWALL [UUCP] (203) 486-5246 [FAX] (203) 486-2489 [PHONE] 41 49N 72 15W [ICBM] The opposite of artificial intelligence is genuine stupidity! -+- I don't speak for my employer, though I frequently wish that I could (subject to change without notice; void where prohibited)