| Subject | Re: [ib-support] Pls, help! What's wrong with this stored procedure? |
|---|---|
| Author | Roland Turcan |
| Post date | 2002-05-14T12:06:35Z |
<<< 14. 5. 2002 14:05 - Andrew Guts "andr@..." >>>
AG> set term ^ ;
AG> create trigger On_Add_RForm for RepForms before insert as
AG> begin
AG> if (NEW.ID is NULL) THEN NEW.ID = GEN_ID(G_RFORM_ID, 1);
?????? AG> NEW.CREATEDATE = 'NOW';
My solution is New.CreateDate=Current_TimeStamp;
--
Best regards, TRoland
AG> set term ^ ;
AG> create trigger On_Add_RForm for RepForms before insert as
AG> begin
AG> if (NEW.ID is NULL) THEN NEW.ID = GEN_ID(G_RFORM_ID, 1);
?????? AG> NEW.CREATEDATE = 'NOW';
My solution is New.CreateDate=Current_TimeStamp;
--
Best regards, TRoland