I just re-read my post and am not sure I was clear enough in the question
I'm asking here, so lemme try again:
I realize vartype() will tell me if a field is numeric, character, etc., but
what can I do to determine what type an index tag is? For example:
Number N(5)
Name C(25)
ZipN(5)
Ind
John
Check out KEY() and SYS(14)
John J. Mihaljevic wrote:
> Hi all,
>
> I've got a Search box on my form that will let the user search the active
> table based upon whatever the current sort order is (the currently active
> index tag). For example, my Customers table.
>
> I want them to be able
John,
Check out Sys(14).
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"
See Ex
Dave Crozier wrote:
> John,
> Check out Sys(14).
>
> 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 ind
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
Ted,
> 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?
There's also the new(?) binary indexes in VFP 9 that are even
smaller/faster in some scenarios.
Malcolm
___
Ted Roche wrote:
> 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
@leafe.com
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
> befor
Malcolm Greene wrote:
> There's also the new(?) binary indexes in VFP 9 that are even
> smaller/faster in some scenarios.
>
Besides an index on DELETED( ), why would you use a binary index? An
example please?
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.
Micheal,
> Besides an index on DELETED( ), why would you use a binary index? An example
> please?
Disclosure: I haven't personally used binary indexes.
Possible uses:
- male vs. female (I recognize this is no longer a binary condition)
- test vs. production
- active vs. non-active
I think t
Malcolm Greene wrote:
> Micheal,
>
>
>> Besides an index on DELETED( ), why would you use a binary index? An
>> example please?
>>
>
> Disclosure: I haven't personally used binary indexes.
>
> Possible uses:
>
> - male vs. female (I recognize this is no longer a binary condition)
> - tes
>>it's for times where the choices are 1/0<<
Yes, that is why they are called *Binary* Indexes - .
Don't worry, you are not the last person to understand this concept.
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.rickschummer.com
586.254.2530 - office
586.254.2539 - fax
_
12 matches
Mail list logo