>Snip..
>>>>The record is in ViewA, but not in base table. TABLEUPDATE() returns F, AERROR() shows Error 1547, "Cannot insert an empty row from a view
>>>>into its base table".
>>>Hi Ed,
>>>ViewA has just one base table-tableA or base tables-tableA, tableB etc.?
>>>Cetin
>>
>>Just one base table. I have to do it through a view because it is a 2.6 table, and I can't include it in a database. So if I want to roll it back, I need to do it with an updataable view.
>>
>>Ed
>
>-ViewA has only one base table (FP 2.x).
>-Base table is not buffered.
>-ViewA buffered opt.table.
>-Fields are set updatable in tableA
>-Sendupdates .t.
>-a rec is inserted in ViewA
>-tableupdate(2,.t.,"viewA") returns false with error 1547.
>
>Well Ed then I'm at a deadend. I can't figure out where the "empty row" is. A funny joke I can think of is some code in stored procs inserting one empty record or tablereverting.
>Cetin

Thanks for your perseverance anyway Cetin.

Ed