Are you using stored procedures or triggers in the database? It sounds like thats where the error actually is.

>Hi everybody,
>
>I've got a very simple updateable view which when I update, either by using tableupdate or just moving the record pointer is returning error 10 - syntax error.
>
>the view looks like this :-
>
>SELECT *;
> FROM build!sections;
> WHERE Sections.divlink = m.divlink
>
>the sections table looks like this:-
>
>divlink char(10)
>seclink char(10)
>desc char(40)
>
>I've got a primary index on the seclink field and in the view it's set as the key field, the other two being marked as updateable. I've tried all the combinations of the sql where clauses without success.
>
>I've created many updateable views in the past, most of which were more complex than this one!, without any problems.
>
>So am I missing something fundamental or is it just because it's Monday
>
>Many thanks
>
>Mark