Chuck,
Use DELETE DUPLICATES to eliminate rows which are
identical. You may choose the specific fields to evaluate
when determining whether a row is identical. This is
helpful when, for example, you have an autonumbered ID field
which differs, but all the other fields are the same. You
could also have the same data except for the date and time
entered.
The syntax is:
DELETE DUPLICATES FROM tblname [USING collist]
Randy Peterson
----- Original Message -----
From: "Chuck Finley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 2:51 PM
Subject: [RBASE-L] - Duplicate Rows
> Hopefully one of you very smart people can help me out. I
imported data into
> a table that contains customer payment information.
Multiple months of
> payments are included in this data. Often all rows are
duplicates including
> a the quantity column. Is there an easy way to compare
rows and when all
> columns are the same to tally the quantity and delete all
rows except one
> and then update the quantity to the correct number. I have
written a cmd
> file that accomplishes this by stepping through the table
with a cursor and
> uses a boatload of nested if / then statements to check is
all the rows are
> exactly the same, but this just seems real inefficient to
me. I hope I am
> missing a way to compare two entire rows. Any ideas would
be much
> appreciated.
>
>
>
