>Using VFP 6. I ran into a curious problem this weekend on an updatable, parameterized view. My source table has a key field with a default value of GetKeyID("TableName", "KeyName"). I pass the actual table and field name to the function.
>
>I know the view is supposed to inherit the default value of the field in the source table but when I Insert SQL into the view, the KeyID value is 0. I do not include the KeyID field in my Insert command's field or values list in order to get the GetKeyID function called. The key id is not valued until I run the TableUpdate procedure. I am using optimistic table buffering here.
>
>Is this normal behaviour? I worked around this by explicitly calling my GetKeyID("TableName", "KeyName") function to return an ID and used that value in my Insert command.

This is normal behavior.