>>I noticed that the update criteria in the view designer defaults to "Key field and modified fields".
>>
>>I suspect "Key fields only" would be more efficient, because the WHERE clause thus generated would only involve the PK. I use a single field for PK; the same field would appear in the view.
>>
>>Any comments?
>
>Hilmar,
>
>I have been taught to use Key fields only. I think I started that way when it resolved a memo field issue. Makes sense that it should be the default instead of the way it is now.
>
>Renoir
Thanks, Renoir and Alexandre, for the information.
Hilmar.
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)