General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only