Re: Triggers problem

try >

:new.OH_FLAG:=1;

                      ^

Bill West wrote in message <702pr0$28c_at_rosebud.sdsc.edu>...
>Tried this code but still getting compilation errors
>
>CREATE OR REPLACE TRIGGER SET_OH_FLAG BEFORE INSERT ON INDEX_FUND_XREF
>FOR EACH ROW
>WHEN (new.FUND LIKE '62100%')
>BEGIN
>:new.OH_FLAG=1;
>END;
>
>Other considerations:
>
>1. I own this table
>2. The FUND is a char datatype
>3. the OH_FLAG is a number with a size of 1 and precision of 0
>
>Bill West
>SDSC
>
>
>
>
>
Received on Fri Oct 23 1998 - 12:52:53 CDT