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.