Re: index ... for <expression> max length

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You're right, but you're splitting hairs. It could be argued the FOR
<condition> is part of the key.

I'd advise against using conditional index expressions anyway since they
don't maintain themselves over time. It would be far better (for performance
and for your blood pressure) to use optimizable full index tags and limit
your data through parameterized local views.

Dan

Lew Schwartz wrote:
Hi Fred:
That info seems to be for the max no of bytes in a *key*. I'm
looking for the max no of bytes in a for <condition> clause.
Thanks.
-Lew
"Fred Taylor" <ftaylor@xxxxxxxx!REMOVE> wrote in message
news:OXkrWXhpGHA.756@xxxxxxxxxxxxxxxxxxxxxxx
Look in the help file under "Visual FoxPro System Capacities".

It's 100 bytes for a non compact index or 240 bytes for a compact
index.

Also note the following:
If the collating sequence is set to MACHINE, each character uses one
byte. If the collating sequence is not set to MACHINE, each
character uses two bytes. If the indexed field supports null values,
one additional byte is used in the index key. Note that non-machine
indexes are always compact.

--
Fred
Microsoft Visual FoxPro MVP


"Lew Schwartz" <lschwartz@xxxxxxxxxxxx> wrote in message
news:OiR4CvepGHA.2464@xxxxxxxxxxxxxxxxxxxxxxx
What's the maximum length for the for expression in a cdx tag?
Thanks. -Lew


.

Relevant Pages

  • Re: index ... for max length
    ... It's 100 bytes for a non compact index or 240 bytes for a compact index. ... If the collating sequence is set to MACHINE, each character uses one byte. ... If the indexed field supports null values, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: 77 to 90/95 assignment question.
    ... most obvious translation to an assignment statement (and note that the ... I've also assumed that the arrays ... if that's what you mean by "compact". ... One caveat in f90/f95 is that the character lengths all need to be ...
    (comp.lang.fortran)
  • Re: 77 to 90/95 assignment question.
    ... I'm not quite sure what you mean by "compact" in this case. ... most obvious translation to an assignment statement (and note that the ... I've also assumed that the arrays ... One caveat in f90/f95 is that the character lengths all need to be ...
    (comp.lang.fortran)
  • Re: how to declare local variable in ewcommand
    ... I want to substitute some character in temp variable before ... assigning it to author variable. ... seems more compact after all... ...
    (comp.text.tex)