Hi,

How can I get the list of all Firebird functions and their usage? I tried this trigger and was surprised that it could not go.

SET TERM ^ ;
CREATE TRIGGER ALLOWANCE_TYPE ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
IF (SUBSTRING(NEW.NAMA,1,8) ='OTHERINC') THEN
NEW.TYPI='S';
ELSE
NEW.TYPI='N';
END^
SET TERM ; ^

At first I used SUBSTR function as contained in the InterBase Doc and got an error message that SUBSTR is not a Firebird function and then used the SUBSTRING and could not get through either.

Can someone please tell me what is wrong with the trigger above and possibly give me a Firebird function rundown.

Best regards.

Tope Akinniyi.


---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!

[Non-text portions of this message have been removed]