>I have a grid that has a list of groups. On that grid I have a column that I want to put the name of the president of the group. I am calling a method on the form to select the president table and find the name of the president based on the member number.
>
>This grid works fine in versions 6,7, and 9 of visual foxpro. But, when I run it in VFP 8 it gives me error 112 "Invalid Key Length" as soon as I select the president table.
>
>It also works fine in VFP8 if I add a relation to the president table but never select it. I looked into error 112 and it does not seem to apply because I don't have an index that is too long.
>
>What is different about version 8 that it gives this error?
>
>Tim
Variable-length index keys are to be avoided, and can cause this problem. For example:
index on alltrim(lastname) tag lastname
If the first record that Visual FoxPro happens to encounter has an empty lastname, then the length of the index key is zero.
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)