Re: insertion with trigger failed unexpectedly

On Monday 12 January 2004 05:57, Anton.Nikiforov@loteco.ru wrote:
> Dear all,
> i have a problem with insertion data and running post insert trigger
> on it.

> When i'm doing tests - everything is going well, but in
> production when multiple records being inserted losses happend.

OK - there must be something different happening with the live situation.
Better post the CREATE TABLE, trigger code and a sample INSERT.

PS -  is the problem:
1. INSERT fails to raw table, and daily is not updated
2. INSERT fails to raw table, but daily is updated
3. INSERT works on raw table but daily is not updated

--
  Richard Huxton
  Archonet Ltd