Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
AutoInc value and CA
Message
De
04/02/2007 13:13:37
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
 
À
02/02/2007 12:25:51
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01191628
Message ID:
01192246
Vues:
12
Hi Mike,
They might complain about keys being 4 or 8 times as large as integers too. :-) That's the tradeoff. One trip to get the key, or use really big keys.
If you store keys as binary, length 16, those keys don't work in comboboxes, which is a pain.

>Hi Borislav
>
>You realize you're hitting the backend/table 3 times? Once to grab the record, once to send the update and once to grab the new ID?
>
>That's the kind of thing DBAs complain about.
>
>By using GUID there are no extra round trips required to get new ids.
Charlie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform