Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Afraid that autoincrementing integer field skips ahead
Message
De
30/08/2010 18:47:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Afraid that autoincrementing integer field skips ahead
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01479307
Message ID:
01479307
Vues:
156
A new free table is being added to an application. It will be the child of a previously existing table.

The parent table unique id is made up of three fields totaling 20 characters. I'm considering adding an auto incrementing integer to the parent table to serve as link to the child table but am afraid what may happen if somehow the id sequence gets out of control and skips ahead to the maximum integer (2^32 - 1), This is a totally critical table in the application.

In the experience of those here, is this a realistic fear? I would appreciate comments.

TIA,

Alex
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform