I've managed to sort out what the problem was, But I need someone to confirm this as it appears to be a bug in the updating of local views.

My original table defination looked like this

divlink char(10)
seclink char(10)
desc char(40)

It seems to be the desc field that is causing the syntax error. If I rename the field from desc to sectdesc it all works as expected.

Can someone set up a table as above, the data would look something like this:-

divlink seclink desc
0000000001 0000000001 John Smith
0000000001 0000000002 Fred Bloggs
0000000002 0000000003 Arthur Brown

create a view that look like this:-

SELECT *;
FROM tablename
WHERE divlink = "0000000001"

Set up the seclink as the keyfield and Update Using to be update, the other two fields are flagged as updateable.

When it retreives the records change the desc and move onto the next record you should receive a 'Syntax Error'.

Ensure that all the tables are closed and reverted

Now change the structure of the table so that the desc field is now named sectdesc and modify the view to pick up the table changes. Run the view and change the sectdesc field move on the next record and it works!!!!

Is this a bug or is there an explanation for this???

Cheers, Mark