tag:blogger.com,1999:blog-7701439.post109041204830265144..comments2023-10-31T15:16:44.297+03:00Comments on Sadettin POLAT - 'S'log/anı/ olmayan 'P'log !: Bu ne la?Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7701439.post-1114089258765154192005-04-21T16:14:00.000+03:002005-04-21T16:14:00.000+03:00CREATE TRIGGER IHALESONUC_BI FOR IHALESONUCACTIVE ...CREATE TRIGGER IHALESONUC_BI FOR IHALESONUC<BR/>ACTIVE BEFORE INSERT POSITION 0<BR/>AS<BR/>declare variable Sonuc Integer;<BR/>BEGIN<BR/> IF ((NEW.ID IS NULL)or(NEW.ID=0)) THEN<BR/> NEW.ID = GEN_ID(GEN_IHALESONUC_ID,1);<BR/> if (NEW.katiteminat IS NULL) then<BR/> NEW.katiteminat=1;<BR/><BR/>/*<BR/> select count(*) from ihalesonuc i<BR/> where i.malzemeid = new.malzemeid<BR/> into :SonucAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7701439.post-1094567943149640342004-09-07T17:39:00.000+03:002004-09-07T17:39:00.000+03:00harbi yaw bu ne la?harbi yaw bu ne la?Sadettin POLAThttps://www.blogger.com/profile/05275127990815502777noreply@blogger.com