Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function Problems
Message
De
18/11/1999 12:07:58
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
18/11/1999 11:55:33
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00292472
Message ID:
00292522
Vues:
24
>what's in your Keys table? nextid and ...? and are any of them primarys?


Actually I have no "keys" table anymore :) When there was I only used TableName and NextId. None primary (since no RI there I don't need a primary). It can even be a free table. Only thing is that it's used unbuffered.
Currently I use character generated PK (bintoc(logonrecno)+sys(2015) - each user lock a record for the entire session in logon table, no problem s/he might have a hangup because recs are logon point specific with data such as netbios id, TCP/IP etc). Downside I spare up to 13 chars for a PK (don't care diskspace as I do in old days :)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform