>It is false, also if first record is NULL,empty or another string or memo field.
>
>
>CREATE CURSOR mcur ( a c(1) null)
>INSERT INTO mcur VALUES (null)
>SELECT LEFT(a,212) f1 FROM mcur INTO CURSOR pippo
>? FSIZE('f1','pippo')
>
>
>If you analize VFP indexing, you found this:
>
>VFP not support variable lenght index keys.
>
>
>INDEX ON cField TAG tag1
>INDEX ON RTRIM(cField) TAG tag1
>
>have equal key set.
>
>Fabio
I assume VFP will index with a minimum length of 1 in this case.
In the past, problems have been reported when selecting or indexing variable-length fields. A command like:
select alltrim(FullName)...
will apparently take the length of the first record it finds to determine the total length. This is not necessarily the maximum length.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)