Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key & Candidate Key Index
Message
From
25/01/2003 08:47:16
 
 
To
25/01/2003 03:04:17
Lakhani Anil
Lakhani Software Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00745042
Message ID:
00745393
Views:
18
I'm not sure why you want a key that large. Integer does a great job and can store values from -2 billion to +2 billion, which should be more than enough key values. Integers will also be faster.

I doubt it is your choice of double that is causing the corruption.

>Yes, since I wnat to store 13 digit number which can be use by numeric 13 or double. But double stores in 8 bytes, while Number will take 13 bytes. Is it overkill? Is it link with corruption of index?
>
>Anil Lakhani
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform