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
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 conditiong)
- test vs. production
- active vs. non-active
I think
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 conditiong)
- test vs.
it's for times where the choices are 1/0
Yes, that is why they are called *Binary* Indexes - bg.
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
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 index as a
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
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 though you
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
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 to enter either a Customer Number or a Customer Name,
and have it
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)
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 to
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of John J. Mihaljevic
Sent: 16 January 2007 18:50
To: profox@leafe.com
Subject: Determining the type of active index
Hi all,
I've got a Search box on my form that will let the user search the active
table based upon whatever
13 matches
Mail list logo