M
ma.u
I'm using Project 2003 database on Oracle 9.2
I have create a trigger on after update of msp_tasks,
and, having to search the summary task of the modified one,
I execute a query on mps_tasks; but I receive an error that
says that it is not possible to make a query on the table
im am modifing.
So I use "PRAGMA AUTONOMOUS_TRANSACTION" in the trigger
and it seems to work corrctly. But there is another problem:
sometimes, when I save from Project, it
__delete all tasks from db__ and the project stop to work...
Sorry for english and thanks to all.
I have create a trigger on after update of msp_tasks,
and, having to search the summary task of the modified one,
I execute a query on mps_tasks; but I receive an error that
says that it is not possible to make a query on the table
im am modifing.
So I use "PRAGMA AUTONOMOUS_TRANSACTION" in the trigger
and it seems to work corrctly. But there is another problem:
sometimes, when I save from Project, it
__delete all tasks from db__ and the project stop to work...
Sorry for english and thanks to all.