>I’m using a local view with its buffer mode set to 5 “Table”.
>
>After inserting a couple of records I use TableUpdate(.t.) or TableUpdate(1) in order to update all the values to its base table.
>
>Only one records is updated into the base table. By trapping the error I know that I’m getting error 1539 "trigger failed".
>
>I have removed al the relational integrity restriction from the table (there are no other triggers) without success.
>
>I assume that the problem is not exactly a trigger error because I can append the same set of data that which is being inserted into the local view directly into the base table without getting any errors.
>
>¿Could it be the parameter(s) passed to the TableUpdate statement?
>
>Is there anything else I should check?
>
>Thanks in advance for any hints.
>
>Oscar Corte
For debugging purposes, try saving the records one at a time (see GetNextModified()), until you get to the record that can't be saved.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)