>This one is strange! I have three parameterized views in my database. One works just fine. The other two have the following problem:
>
>If I attempt to edit a key field in the view and then issue TABLEUPDATE(2, .t., ALIAS(), aSaveErr) it works just fine. But if I edit a non-key field, such as a description field, and issue the same TABLEUPDATE command, it fails. I then issue AERROR(aSaveErr) to see what the error is and it returns error 10, Syntax Error. What is even stranger, is that once the TABLEUPDATE fails, other commands I issue in the command window fail with a Syntax Error. Even typing "QUIT" returns a Syntax Error. I have to CTRL-ALT-DEL to get out.
>
>I've ran the GENDBC program and it ran just fine and seems to look fine. I've erased the database and tables and recreated them using the program created by GENDBC. I've even reinstalled VFP 6.0 and SP3.
>
>Has anyone ever encountered this? I'm pulling my hair out on this one.

Hi Cathy-

What is the view's Update type? Is the field type of the view field the same of the field type of the table?

You should download my eView utility and look at the update names, and recreate the view through eView to see if it can purge any view definition problems.

BTW, the reason that you get syntax errors when you try to quit VFP, is that the view is opened with row buffering and is attempting to write it's changes before closing. You can issue a TABLEREVERT(.T.) to escape this.