>>>>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.
>>
>>So THAT IS the answer!
>>Thanks!!!
>
>
>Tommy, were you getting the error on use (add/edit)? Or on the creation of the initial INDEX? I thought you were getting it occasionally on the INDEX ON command itself.
The error would always occur on the line of code that would assign the value of 5 to 'status' of the new record in ss_io.
The record was created new by an APPEND BLANK, then values were assigned to various fields, then when we got to 'status',
BOOOM
everytime.
Thanks!
Tommy Tillman A+ NetWork+ MCP