戻る

トリガー定義の例

0001: CREATE TRIGGER TR_SEQNOORDERTAB FOR ORDERTAB
0002:    BEFORE INSERT
0003:    AS
0004:       DECLARE VARIABLE MAXSEQ INTEGER;
0005:    BEGIN
0006:      SELECT COUNTMAX FROM COUNTERTAB WHERE TABLENAME='ORDERTAB' INTO MAXSEQ;
0007:      IF (MAXSEQ IS NOT NULL) THEN
0008:         BEGIN
0009:           MAXSEQ=MAXSEQ+1;
0010:         END
0011:      ELSE
0012:         BEGIN
0013:           MAXSEQ=1;
0014:         END
0015:      NEW.SEQNO=MAXSEQ;
0016:      UPDATE COUNTERTAB SET COUNTMAX=:MAXSEQ WHERE TABLENAME='ORDERTAB';
0017:    END

この HTML を検査する。( XHTML 1.0 Strict で書かれています )
Another HTML Lint Gateway ( Mirrored by htmllint.oosato.org )