How to properly select records

Kenneth Brody kenbrody at bestweb.net
Thu May 4 10:32:03 PDT 2006


Quoting Dan Snyder (Thu, 4 May 2006 12:35:23 -0400):

> Hello everyone,
>
> I'm trying to select some records for printing and I'm having trouble.
> Hopefully someone can help.
>
> Here's my select statement.
>     @PM eq 1 AND aa eq 9 AND @PZ eq 7
>     select
>
> The problem is when @PM is part number 649D5069H01, the select statement
> also matches/selects a record for part # 649D5069H01WK.  How can I make
> it select only an exact match?
[...]

Remember, text field compares are based on the shorter field.  If
@PM is 11 characters long, it will only compare to the first 11
characters of field 1.

If you want to make sure filePro compares all 20 characters, then
store @PM into a (20,*) field first:

 Then:  xx(20,*) = @pm
   If:  xx eq 1 and aa eq 9 and @pz eq 7
 Then:  select

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list