Update Trigger ?

[ikh]

I need to write a simple update trigger which should do following: update a logical field with .T. if any other fields changed. I wrote few lines of code that I thought should do it, but I am failing with "Cannot update cursor" error. Can somebody help???

 

[Guest_imported]

Hello,

It's not that difficult but try this simple thing.
I guess you are using
- more than one table
- sql cursor table

Therefore, somewhere it gets lost before you try to update. maybe it is pointing to the cursor.

select the <table name> before you update the required table.

Thanks

 

[EdLeafe]

Is the field you are updating in the same table? You cannot do that via a trigger then. Think about it: the trigger fires, and then changes a value in the same table, which fires the trigger, which changes a value in the same table, which fires the trigger, ... in other words, and infinite loop. You can update a separate table in a trigger, but not the table on which the trigger is firing.

== Ed Leafe

 

[ikh]

Can't I use optimistic buffering and compare curval() with oldval() for all fields except this logical one ???

 

[rgbean]

Nope! Triggers are meant for validating data, maintaining referential integrity (between tables) and &quot;auditing&quot; to another file - not for fixing fields in the same table.

Rick