tag a record
Kenneth Brody
kenbrody at bestweb.net
Wed Apr 27 13:14:45 PDT 2005
Quoting Steven Waters (Wed, 27 Apr 2005 12:25:32 -0700):
> G-day,
> I am writing a small program that I want
> to tag with a "X" duplicate P/N's in a file.
> I can't figure out how to get the first instance
> of a duplicate P/N. For example if there are 3 records
> with the same P/N I only get a "X" by record 2 and 3. record 1
> is not X'd.
>
> 1 ------- - -
> If: 1 eq ab
> Then: 12="X";end
> 2 ------- - - -
> If: 1 ne ab
> Then: ab(40,,g)=1
[...]
(Note that the if on line 2 is unnecessary, as it can't get there if 1
is equal to ab. Not to mention that if 1 is equal to ab, the assignment
won't really have any effect anyway.)
This should work if you run this in *report while sorting on field 1.
--
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