>Hello!
>
>Recently I have had play with this and have curious results. When you check
>Send SQL updates in View designer, then all changes in view goes in parent
>table immediately and you cannot make the rollback ;( (tablerevert()
>doesn't work) For deleteting records you can use Delete command. May be
>I'm misunderstand your question?
>
>Have a happy day
>Vladimir Shevchenko
>
>> The title says it all. Has anyone found a way to create new records or
>> delete records from a view? Is it my correct understanding that one can
>> only "update" existing data in a view?

Hi Vladimir,

I do not use the View Designer as some of our views will be far to complex for it. All is done through code. I gone through the whole DBSETPROP bit, including tables, keys, names, updatable, and sendupdates. I have a transaction class that issues the tableupdate() function and it returns .T. so all apparently went well. The view is updated on the form, but the underlying table does not get updated.

Steve Despres