Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key & Candidate Key Index
Message
From
25/01/2003 11:29:53
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
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:
00745416
Views:
26
>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?

VFP attempts to do index key compression. Storing keys as doubles MAY not work as well as character or integer if VFP fails to find a pattern in the binaries. You may have a smaller DBF, but may wind up with a bigger CDX. A few tests might be in order.
Previous
Reply
Map
View

Click here to load this message in the networking platform