>bob, thanks for the tip on the gendbc tool. i ran the thing and looked at the code and it looked very similar to things that i had tried manually. however, i did not try explicitly setting everything. unfortunately, even after cutting the code i needed from the gendbc results and changing what i thought i should i still can't get it to work.
>
>do you have any more advice on what i may want to try?
>
>thanks, pbd


Here is a line from Gendbc from one of my views.

DBSetProp('RV_SNAPPBRINGFORWARD', 'View', 'Tables', 'dbo.bringforward,dbo.tsnbringforward,dbo.V_CodeDetail')

To make sure that v_codedetail would not be updated, I could remove it from this statement. This won't affect the query, but will prevent tableupdate from trying to update the table when no fields are chosen.

If everything looks good, post the code from gendbc and I might spot something there. My first rule of programming says, "If you've done everything right and it still doesn't work then something you've done right is wrong."

The only view I found that could not be made updateable was a complex view with an outer join, and even then I found I could add records, edit records (from the primary table) but not delete records!