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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05