That could be. Here's what you do: Edit the SQL code that creates the view and put quotes around the table name. IE:

SELECT * FROM "group"

This might alleviate the problem.


>I am updating a single record in a table, Group, with a view, ModifyGroup. Probably a bad choice of table name, but it's inherited...could this be causing the problem?
>
>MOST of the time the TableUpdate works...
>
>In a certain case, after the table is updated, I want to revert to a previously saved state of the table. I REPLACE fields of the view with the previous values and when I do a TableUpdate, it fails...and AERROR() tells me: Syntax Error.
>
>Any help on ideas about what could be causing this, or a solution? TIA, J