>I have been given a conversion file of customer numbers. Follows the typical old_cust, new_cust format. Every customer number on every DBF will have to be renumbered. There are 12 tables. Some sites will have tables that are 32mg with 250,000 records. Each record contains a customer number.
>
>Looking for an efficiency way to renumber. I am hoping there might be a better way than reading the conv_cust file in a loop and taking each record, and doing a REPLACE WHERE on each of the 12 tables. Not terrible, just looking for maybe a better way.
>
>Thanks
>
>Brenda
How about something like
SELECT 0
USE ConversionTable
INDEX ON OldCustomerNumber TAG OldCustomerNumber
SELECT 0
USE maindatatable
SET RELATION TO CustomerNumber INTO ConversionTable
REPLACE ALL CustomerNumber WITH ConversionTable.NewNumber FOR FOUND("ConversionTable")