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