Good day everyone..
I am tried to write a process to delete the duplicate Customer Name.
If EXISTS Customer WHERE (Customer.Name=ThisCustomer.Name AND Customer.ID<>ThisCustomer.ID) Then
FIND Customer WHERE Customer.Name=ThisCustomer.Name AND Customer.ID<>ThisCustomer.ID
DELETE Customer
Assume, there is 2 rows of record with the name called "Peter"
The process found only 1 rows of duplicate record, next action.. delete customer...
But the process delete all the customer record.
From the user guide I found this: DELETE Account WHERE Account.Name=’Smith’
So I wrote: DELETE Customer WHERE Customer.ID <> ThisCustomer.ID
But the system give me error message: Syntax Error at Token "Where"
The objective is to delete the duplicate record and remain one.
Please advice....
