Hi!

What error message(s) you receive in aerror() function after tableupdate() fails? If you update multiple records, you can also use array parameter of tableupdate() to see which record are problematic.
If no errors, check if view is really updatable.

>Hi,
>
>I have 2 .dbc's for my app, 1 contains all the tables, the other local views of the tables.
>
>I have a little program that enables me to change the structure of the tables when necessary. This is all done through the .dbc (alter column add row etc) and every thing seems fine, all the SQL update requirements for the modified tables are either selected or ticked, both .dbc's validate OK, however when editing or adding a new record to the buffered row of the view and issuing tableupdate(.t.), the update fails.
>
>The other common denominator is that the fails are from modal forms called by a non modal form with a private datasession.
>
>My development system which has had the mods to the .dbc's done by hand works OK, it is just the real (clients) version that plays up.
>
>Regards
>Doug Johnston