>>So....... someting in VFP 9.0 Service Pack 1 fails in the Index Tag if you use DTOC against a datetime field.... also, there is a built in filter with the tag too.... "status = 5" for the filter. If it helps in understanding this error.
>
>MS changed the behavior of indexes to not allow potentially variable length keys. DTOC() can potentially have a variable length depending on how SET CENTURY is set.
>
>Doug


Doug, is this feature you mention enabled in VFP9? How is/was Tommy able to use the INDEX ON DTOC(x) FOR... expression (x being datetime) to initially create the index if MS disallows potentially variable length keys? It only failed for Tommy on the update, yet I would think it should fail at all points if such a feature were enabled as a rule.