Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unintelligent keys
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00224729
Message ID:
00224740
Vues:
17
>>>If my primary key is an unintelligent key that's an integer type, I can use only 4 places. What if I have more than 9,999 records in the table? Am I missing something fundamental?
>>>
>>>Thanks.
>>
>>While an integer is stored in only 4 bytes in a file... it actually has a range of +/-2 billion and change. So, you can store 2345678 (etc) in an iteger field.
>>
>>BOb
>
>Is it using values other than numbers? How does it make it unique? SHould I just trust that it will work and not wonder why?

Hi Jane,

PMFJI, but it is using only numbers. A signed integer takes up only four bytes of memory. As such, in their normal format, they're not easily recognizable in terms of value. However, VFP will display them properly as integers.

FWIW, the information is stored in a low-byte to high-byte format. Each byte contains a value between 0 and 255 which is used to comprise the entire value.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform