>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
This one is almost always caused by a field with the same name as an SQL key word. Common offenders are DESC, GROUP, ORDER etc. When VFP generates and executes the SQL that updates the view, the SQL engine gets confused by "keywords" appearing in the wrong place in the statement. Key lesson:
NEVER use an SQL keyword as a field name. VFP keywords you can usually get away with...
Erik Moore
Clientelligence