General information
Category:
Coding, syntax & commands
Title:
Local view returning syntax error
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only