Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to resequence records in a table with an index order
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
Suivant
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