Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unintelligent keys
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00224729
Message ID:
00224740
Views:
16
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform