Ted, I agree but my point was that however you generate the index it is always going to physically be a fixed length string packed/encrypted or otherwise. The fact that it is a particular data type is irrelevant as the "mapping" in VFP is always down to a fixed length character based field (however that is formatted) unless we get onto variable length keys of course but that is another discussion on a range of other products!
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 18 January 2007 00:01 To: [email protected] Subject: Re: Determining the type of active index On 1/17/07, Dave Crozier <[EMAIL PROTECTED]> wrote: > > However, always remember though that there is no such thing as a "Numeric" > index as all the data you index on is converted to a character expression > before it is indexed. Hence you can seek on a character key even though you > created the index as a "numerical index" > I know that was true back in the FoxBase days, but aren't integer indexes smaller than other types because they are packing integers rather than converting them to strings? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
