I've a table with 3 fields: i,u,d;
3 triggers: write_i, write_u, write_d
write_i is a stored procedure wich only action is:
Replace i with dtoc(date())
write_u has the instruction replace u with dtoc(date()) and so on.
the problem is that none of the triggers works; there's always a message: "Cannot update the cursor".
Why is this happening?
Is not possible to change a field in the table in wich the trigger occurs during its execution?
Is there any way to make this work?
TIA.
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.