Path: utzoo!utgpu!watmath!iuvax!silver!tsui From: tsui@silver.bacs.indiana.edu Newsgroups: comp.databases Subject: Re: foxbase problem, need help Message-ID: <20900011@silver> Date: 29 Jul 89 04:28:00 GMT References: <20900010@silver> Organization: Indiana University CSCI, Bloomington Lines: 24 Nf-ID: #R:silver:20900010:silver:20900011:000:891 Nf-From: silver.bacs.indiana.edu!tsui Jul 28 23:28:00 1989 /* Written 9:04 pm Jul 28, 1989 by englandr@phoenix.Princeton.EDU in silver:comp.databases */ It's hard to tell exactly what you're doing, and what i know is based on fairly little experience with the Mac version 2.0 of Fox, but here's my $0.02. Shortening line length of conditions: I have run into this on the Mac; the limit is 255 characters. On thing i discovered about expressions is that spaces are absolutely extraneous. So strip them, if you haven't already. Also, why do you need the ()s around the field names? - Scott /* End of text from silver:comp.databases */ I have already striped the spaces. The reason why I put ()s there is that The users can put ! to stand for .NOT. For example: filed[2] input : !This is right then the code becomes: condition = condition + ".not."+.... Sorry I did not specify that. --yufeng