Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto-increment with letters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Auto-increment with letters
Divers
Thread ID:
00108240
Message ID:
00108240
Vues:
89
I have made auto-incrementing keyfields before, using the system in TASTRADE. What would be a good system for auto-incrementing while having each "digit" cycle through a-z, or maybe 0-9 and a-z, or maybe A-Z and then a-z? Doing this would increase the number of available values. It would be useful to me because I have a legacy app, written using data from other people's legacy apps, which has a meaningful keyfield which is only five characters long, and always starts with a digit. Now they want to allow blank values in this field, and we don't feel like rewriting the whole thing. I propose to generate values always starting with a letter, which would appear as blank in reports.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform