Updates to the ITEM table

Brian Crampton — Thu, 15 Feb 2007 08:09:48 +0000

Whenever the ITEM table row is inserted, updated or deleted then a row is inserted into the ITEM_UPDATE table by triggers on the ITEM table. Only certain details are inserted into the ITEM_UPDATE table e.g date, status change, WORK_ID change, location of change, operator.

There is an article called Bulk updates of the ITEM table that talks about updates to the ITEM table.

Thanks

Brian Crampton
Developer, Talis

Bulk updates to the Item table

Julie Hart — Wed, 14 Feb 2007 17:16:18 +0000

If you run sql to bulk update the item table is the update recorded somewhere?

Talis Developer Network - Bulk updates to the Item table - Comments

Updates to the ITEM table

Bulk updates to the Item table