Information générale
Catégorie:
Codage, syntaxe et commandes
Not sure I understand exactly what you mean, but how about:
SELECT DISTINCT custtID, ... FROM... ORDER BY custid INTO TABLE...
Then zap the original and append the new table into it.
-Michelle
>Want to resequence my customer records, within customerid. Had a program bug that resulted in some sequence number gaps and duplicates. I first open cust.dbf and then order by custidseq. As I replace the sequence number, some records are bypassed.
>
>CustID Seq
>123 1
>123 1
>123 1
>123 2
>333 1
>333 2
>444 1
>
>When record #2 is resequenced to 2, then because of the custidseq order, record #3 is bypassed.
>
>What is a good way to requence?
>
>Brenda
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement