...
>>
>>But with buffered data triggers wouldn't fire till tableupdate(). Maybe you're misinterpreting the change thinking it has changed ?
>>Cetin
>
>No. I actually wanted to change a bad date field on the record. I was not permitted to make that change (TRIGGER FAILED). OK so on a hunch, I tried to change the pclose_ID field on the same record. I was allowed to do so. Then I changed the bad date field successfully. But now I cannot change the pclose_ID from 0 to 8. I have closed the table and the database. Opening again reveals the date has changed and the closep_ID is 0 but I still cannot change it.
>
>Thanks,
>
>Ken
Ken,
Retest. I think you never changed it from 0 (unless initially 8 - no code for insert trigger). Being on the same record and not issuing an explicit tableupdate(), probably you only had the illusion you could change it from 0.
When it's a trigger it applies to all fields including the Closep_id field to be able to update. If it were say a field validation rule instead for fields other than closep_id then you could freely play with the flag.
Or with trigger you might do something like :
GetFldState('closep_id') = 2 or Closep_id = 0
Cetin