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