Re: [GENERAL] Trigger problem 2

2004-12-01 Thread Richard Huxton
Jamie Deppeler wrote: UPDATE wip.resource set "name" = datarecord.borname where wip.resource."primary" = OLD."primary"; get the following error Error: record "old" is not yet assigned If called from an INSERT then OLD is undefined, since there is no old version of the row. -- Richar

[GENERAL] Trigger problem 2

2004-11-30 Thread Jamie Deppeler
Hi Finally getting this trigger ro work have one last problem, im trying to use Trigger variables sample code UPDATE wip.resource set "name" = datarecord.borname where wip.resource."primary" = OLD."primary"; get the following error Error: record "old" is not yet assigned would be grea