>Hi all,
>
>I'm trying to create updatable local views from a common code table. I seem to keep getting a 'Syntax Error' as soon as I make any data change in the view. There is no way to exit except by an 'End Task'.
>
>I'm using VFP 6.0/SP3. No code is involved in what I'm trying. This is all interactive...
>
>Any assistance would be greatly appreciated.
>
>Henry

Erik Moore has got a View code generater in the Files section. The view builder is notorious for mangling code when doing anything but the simplest views. You're probably going to have to create this view in code.

HTH